Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
MNREDDY
Contributor
Contributor

Multiple enclosures in the text in csv input data

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

Labels (3)
1 Reply
Anonymous
Not applicable

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