replace lf with space but not cr

Anonymous — Sat, 16 Nov 2024 04:52:03 GMT

Is there any way in Talend to replace a lf (linefeed) character with a space but not affect cr (Carriage return)?
I've tried to modify the input field in my tmap with replacing \n with a space with no change. I've also tried the tReplace searching for \n to replace with a string with no change.

the input text would be something like with | as a separator
field1 | field2| field3 some textLF
more textLF
more text|field4 | field5 CR

which I would like to see in the format of
field1 | field2| field3 some text more text more text|field4 | field5 CR

Re: replace lf with space but not cr

TRF — Sun, 25 Aug 2019 13:41:45 GMT

Use tFileInputFullRow to read the input file with \r for the row separator and line.replaceAll("\\n", " ") to replace \n all by spaces.
It should work (maybe \n istead of \\n).

topic replace lf with space but not cr in Talend Studio

replace lf with space but not cr

Re: replace lf with space but not cr