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
