Reading .csv files with CR LF in string considers it's a new record

[ANNE_LEROY]

Hello,

I have an issue when reading a .csv file where there is in the middle of a string field a CR LF.

It considers that it is a new record starting from the CR LF, even if it is inside  a string field .

Thank you for your precious help

Anne

[davidskaife]

Hi @ANNE_LEROY 

What are you using as the delimiter in the Input Data tool? You can try \0 which is basically no delimiter, and should bring in the csv without splitting anything

[ANNE_LEROY]

I used a delimiter that does not exist in my data => ####

I tried with \0 as suggested; but it still split me the record in two

[ANNE_LEROY · Accepted solution]

I found it.

There is another option which is called : AMP only : Allow newlines in quoted fields

😊

@davidskaife  Thank you for your suggestion of \0, it's interesting to know