topic In Delimited file handle file with commas in Talend Studio

In Delimited file handle file with commas

Joyjit — Fri, 12 Jul 2024 07:13:26 GMT

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.

Re: In Delimited file handle file with commas

dacca — Mon, 15 Jul 2024 10:40:22 GMT

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

Re: In Delimited file handle file with commas

Xiaodi_Shi — Wed, 17 Jul 2024 01:45:58 GMT

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