tFileInputTextFlat handling of records with comma within quotes

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

Highlighted
Six Stars

Re: tFileInputTextFlat handling of records with comma within quotes

In which Version of talend there is  a tfileinputtextflat - component ???
Highlighted
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?
Highlighted
Four Stars

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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog