tFileInputTextFlat handling of records with comma within quotes

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

Six 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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads