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.