[resolved] tFileInputDelimited and newline in cell

[Anonymous]

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 ?

[Anonymous]

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

[Anonymous · Accepted solution]

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