Four Stars

tFileInputTextFlat handling of records with comma within quotes

Column1,Column2
ABC,DEF
"ASD,F",Z


How can I handle above case where in the record details there's a comma within the quotes, and my field separator is ",". 

3 REPLIES
Four Stars

Re: tFileInputTextFlat handling of records with comma within quotes

In which Version of talend there is  a tfileinputtextflat - component ???
Four Stars

Re: tFileInputTextFlat handling of records with comma within quotes

In which Version of talend there is  a tfileinputtextflat - component ???

This is a custom component from Talend Exchange - link
Have got in touch with the developer, waiting for response. Has anyone encountered similar problem?
One Star

Re: tFileInputTextFlat handling of records with comma within quotes

Hi, you need to set Field Separator as ","
and tick 'Use Enclosures'
Set Text Enclosure as "\""
There is also a 'Allow Enclosure within Content' which I didn't need to check.