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