Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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