topic Re: output csv delimited from excel in Talend Studio

output csv delimited from excel

JM39 — Sat, 16 Nov 2024 01:32:05 GMT

Hello, I have an input file in excel format and I want the output to be in csv format, which is fine. But some of my data contains commas so where it finds a comma in the data it creates an extra column in the output file. How do I get it to ignore the commas in data?

Example:

Input file shows the column supplier name:

Supplier Name

Extron Electronics, Europe

But in my csv output file it splits it out into two columns like

Supplier Name Column2

Extron Electronics Europe

Thanks!

Re: output csv delimited from excel

JM39 — Fri, 04 Sep 2020 15:11:08 GMT

Also I need to retain the commas in the data. So in my example I need the output file to show the supplier name as Extron Electronics, Europe

Re: output csv delimited from excel

JM39 — Fri, 04 Sep 2020 16:52:05 GMT

I got the answer. Changed my input file to delimited

Re: output csv delimited from excel

Anonymous — Mon, 07 Sep 2020 08:33:13 GMT

Hello,

Thanks for letting us know that you resolved this issue by yourself.

Best regards

Sabrina