remove new line character from text file

Anonymous — Wed, 02 May 2018 11:30:04 GMT

Hi,

In the middle of my text file that is the data source there is a newline character at some random points. It's produced by someone else's system and I don't have control over the format coming to me.

Normally, all my lines should start with a date format like "dd/MM/YYYY HH:mm". So Basically what I need is a way to concatenate my lines that doesn't start with a date format to the previous one.

Example of input :

09/05/2017 16:52:51 JOB
_Ref_IO810 
09/05/2017 18:39:10 JOB
_Ref
_IO811

What I need on the output :

09/05/2017 16:52:51 JOB_Ref_IO810 
09/05/2017 18:39:10 JOB_Ref_IO811

Any Idea on how to do this?

Re: remove new line character from text file

TRF — Wed, 02 May 2018 11:43:33 GMT

Enclose the source file fields between "" like this

"09/05/2017 16:52:51" "JOB
_Ref_IO810"
"09/05/2017 18:39:10" "JOB
_Ref
_IO811"

If not possible, refer yourself to this post for a more advanced solution based on tMap variables.

The 2nd approach is the way if you really want to remove the undesirable line feed.

topic Re: remove new line character from text file in Talend Studio

remove new line character from text file

Re: remove new line character from text file