topic Multiple enclosures in the text in csv input data in Talend Studio

Multiple enclosures in the text in csv input data

MNREDDY — Sat, 16 Nov 2024 07:21:12 GMT

I have a set of CSV data with comma as the field separator and double quote(") as the text enclosure. In some of the fields the text enclosure character is in the data. Here I can't change the delimiter.

Input csv file.

ID,NAME,CITY

"1","ABC","HYD,BLR",DEL",MUM"

Output.

ID,NAME,CITY

1,ABC,HYD,BLR,DEL,MUM

Re: Multiple enclosures in the text in csv input data

Anonymous — Thu, 08 Nov 2018 09:54:19 GMT

Hi,

My suggestion would be to change the text enclosure character for the source file to something distinguishable (may be a combination of two characters) from the actual data. You can always replace the extra double quotes later in the flow by replacing them with empty characters.

Warm Regards,

Nikhil Thampi