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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Banupriya
Contributor III
Contributor III

Escape char and text enclosure functionality

Hi All,

Our requirment is to process a, ",|" (Pipe) delimited file having, "|" (Pipe) enclosed within double quotes for some of the fields. We need to ignore the pipe that enclosed with in double quotes while processing.

We tried implementing CSV option enabled with escape char : ,"\|"​ and Text enclosure : """, but it did not work as expected.

We need a same output as input with out any modification for one of our requirment.

Example

INPUT

Col1|Col2|Col3|Col4

123|BE|," Ram|kumar"|24

Expected output

Col1|Col2|Col3|Col4

123|BE|," Ram|kumar"|24

Please need your suggestion.

Thankyou

Labels (3)
1 Reply
Banupriya
Contributor III
Contributor III
Author

Any one please guide here​