Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-05-13 05:23 AM

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

Labels (2)
Labels
300 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2016-05-13 12:53 PM
Author

In which Version of talend there is  a tfileinputtextflat - component ???
300 Views
0 Likes
Anonymous
Not applicable
‎2016-06-06 11:49 PM
Author

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?
300 Views
0 Likes
IanM
Contributor III
Contributor III
‎2016-06-20 08:59 AM

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.
300 Views
0 Likes