topic [resolved] tFileInputDelimited and newline in cell in Talend Studio

[resolved] tFileInputDelimited and newline in cell

Anonymous — Sat, 05 Sep 2015 13:14:15 GMT

Hi,

Today, my question is about a CSV input file where some cells may contain some "newline" characters, that is for instance :

Col1  | Col2           |
-----------------------
0001  | blabla.        |
-----------------------
0002  | blabla:
      | blabla, blabla.|
-----------------------
0003  | etc            |

Separator would be here |.

So far, I've not been able to deal with these splitted lines under TOS DI. While LO Calc opens and shows them properly, tInputFileDelimited considers 2 differents input lines for the input line where Col1 is 0002, which is not what's expected...

The tFileInputDelimited line separator is set to \n.

What should I configure to keep these cells unsplitted ?

Re: [resolved] tFileInputDelimited and newline in cell

Anonymous — Sun, 06 Sep 2015 04:29:16 GMT

Hi
Have a try to copy the "newline" character from your file and paste it to Field separator.
Best regards
Shong

Re: [resolved] tFileInputDelimited and newline in cell

Anonymous — Mon, 07 Sep 2015 10:23:42 GMT

I solved it by exporting the CSV file from LO Calc with text lines enclosed in ".