One Star

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

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Community Manager

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

Hello
It is a csv file, you need check the 'csv' option and set the escape char as"\"", text enclosure as "\"".
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
2 REPLIES
Community Manager

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

Hello
It is a csv file, you need check the 'csv' option and set the escape char as"\"", text enclosure as "\"".
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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