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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
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​