Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Joyjit
Partner - Contributor
Partner - Contributor

In Delimited file handle file with commas

The user is looking for a way to handle commas within the data (e.g., "1,queen avenue") in a column (e.g. street) of a CSV file when processing it in Talend Open Studio.

Labels (2)
2 Replies
dacca
Contributor
Contributor

Since you don't need that column, you can delete it on-import.

Instead of double-clicking the CSV to open it into Excel, have Excel open already, and then initiate the import from there:

Click Data (on the ribbon) > Get Data > From File > From Text/CSV (that will open the import wizard dialog/window)

In that window, click the Transform Data button down toward the bottom right (that will bring up the Power Query editor)

In the editor, select the header of the column you don't need, and then (in the Home section of the ribbon -- should be in that section by default initially) click the Remove Columns button

You can do any number of other manipulations on the data that you might want to inside that PQ editor there (such as making sure certain columns are set to the correct data-type, doing some sub-splitting of data if/as/when/where necessary -- all kinds of things you can do)

Then click Close & Load

 

Xiaodi_Shi
Support
Support

Hello,

What does expected result look like? Talend will know how to handle the commas in the address and you could check option "CSV options" in tfileinputdelimited component to specify the csv parameter.

https://help.talend.com/en-US/components/8.0/delimited/tfileinputdelimited

Best regards

Sabrina