topic tFileInputTextFlat handling of records with comma within quotes in Talend Studio

tFileInputTextFlat handling of records with comma within quotes

Anonymous — Fri, 13 May 2016 09:23:33 GMT

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 ",".

Re: tFileInputTextFlat handling of records with comma within quotes

Anonymous — Fri, 13 May 2016 16:53:53 GMT

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

Re: tFileInputTextFlat handling of records with comma within quotes

Anonymous — Tue, 07 Jun 2016 03:49:40 GMT

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?

Re: tFileInputTextFlat handling of records with comma within quotes

IanM — Mon, 20 Jun 2016 12:59:07 GMT

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.