topic Re: Carriage return | Multiple rows in a single field in Talend Studio

Carriage return | Multiple rows in a single field

MEureka1636576605 — Fri, 15 Nov 2024 23:31:58 GMT

Hi team,

I have aan input file with multiple fields. Some of the fields has CR or \r in the flow so as to continue data in single field but in a new row:

Field1;Field2; Field3

1;abc;Hello

2;xyz;Hello\rWorld\rBye

This should eventually be fed in the table as:

Field1|Field2|Field3

1|abc|Hello

2|xyz|Hello

World

Bye

I tried different posts the solution doesn't seem to fit to my needs. Can someone help?

Regards,

Eureka

gjeremy1617088143 — Fri, 19 Nov 2021 08:22:25 GMT

Hi, you can try to read the file with tFileInputRaw then you replace \r with the end of line you want :

input_row.replaceAll("\\\\r","\\n") if you want LF

input_row.replaceAll("\\\\r","\\r\\n") if you want CRLF

input_row.replaceAll("\\\\r","\\r") if you want CR

or then you can write it with tFileOutputRaw.

finally you can read the new file corrected.

Send me love and kudos