Try changing the CSV Format to Excel and put the escape character back to \ (backslash).
I believe the CSV format definition defines the handling of double quotes separately from an escape character. I know Excel handles double-double quotes by default, tho. Fyi - """Teahous"" Beijing People's Art" after the removal of surrounding quotes and special handling of double-double quotes should end up as "Teahous" Beijing People's Art On Tue, Sep 17, 2019 at 5:35 PM KhajaAsmath Mohammed < mdkhajaasm...@gmail.com> wrote: > Hi, > > I am using the CSVReader to read the data from the csv files. > > [image: image.png] > > Here is the sample data I have it. > > "A"|"""Teahous"" Beijing People's Art"|"""Teahous"""|" > > With the above CSV reader, " are completely removed. My expected output > should be *""Teahous"" Beijing People's Art* for the value *"""Teahous"" > Beijing People's Art" . * > > any suggestions please? > > Thanks, > Asmath > -- Eric Ladner
