Single quote issue

Hi All,
I am facing issue while parsing a csv file data with quote character as single quote and comma separator and some of the data has single quote in it and i need to remove those single quotes but while parsing itself parser is throwing error how can i remove those single quotes in the data
data looks like this

Please could any body help me to fix this

Hi @rashmi ,

I have attached a sample pipeline and the input file that Iā€™m using.
Please check if it works for you and let me know.

sample input.txt (50 Bytes)
csv_single_quote_2022_05_31.slp (8.9 KB)

1 Like