Five Stars

remove new line character from text file

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?

 

1 REPLY
Forteen Stars TRF
Forteen Stars

Re: remove new line character from text file

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.

 


TRF