I have a csv source file with comma (,) delimiter and values are enclosed with double quotes (") and using Text file Input to read the data in PDI 8.3. I am using , in Separator and " in Enclosure options in Content tab.

However, there is a field that contains quotes within the double quotes in the values itself, see the example below:

"abc","cde", "abc" - 1st col "cde" - 2nd col "ef"A"gh" - 3rd col "ijk" - 4th col and so on..

And issue in the 3rd col, in output it's reading "ef" as 3rd col and remaining values is passing to the next subsequent col. Hope I am able to clarify the issue here, only Expecting to escape the " within the values.

I have tried " in the Escape option but it's not working. Can someone please suggest how to handle this.

Thanks!