[resolved] How to handle CSV data "X","Y", ... "xx , zzzz"

[Anonymous]

Hello,
I got a CSV file resulting from DBF2CSV convertion.
I wander how I could read this file with TOS as Excel does when converting data. The comma is the colum separetor. But each column value begins and ends with <">. How can I handle this? I didn't find any specific settings in the metadata source definition.
tFileInputDelimited -> tLogRow
I got error!
my CSV file sample
"ID_BADGE","CODE",...
"20000002",...
starting job testReadCsvFiles at 14:26 02/02/2010.
For input string: ""20000002""
...
I also have to handle data such as adress definition with comma inside the value "101, rue X".
Thanks in advance for any help.

[Anonymous · Accepted solution]

Hello
It is a csv file, you need check the 'csv' option and set the escape char as"\"", text enclosure as "\"".
Best regards
shong

[Anonymous]

Thanks, I tried the escape char but missed the right one !