Problem reading CSV file, version 7.95

[c4ddanyse]

When a CSV file contains a quoted field and there are more than two consecutive linefeeds (crlf) i get an AV. This is because the second empty line sets FLine to empty string. The AV happens in the tree checks for FCSVQuote. I changed the (three similar lines) lines to:

if (FLine <> ”) and (FLine[Flptr]=FCSVXxxxx) then

but that only makes it work for me as i do not map that field to an actual field.

My CSV looks something like this, duplicate crlf’s in the end of field2.

field1;field2;field3

10;”

Hello

From: Me

To: You

—-

 

 

“;html

Regards,

/Dany

• This topic was modified 4 years, 3 months ago by c4ddanyse.

[kimbomadsen]

Hi,

The CSV format used by kbmMemTable do not support unencoded CR/LF in the data. You can however encode them by using %c and %n which will be interpreted as CR and LF respectively.

Kim/C4D

[Author]

Posts