Thanks. May I know the controller service for this. I dont see that option in CSV reader.
On Tue, Sep 17, 2019 at 5:51 PM Eric Ladner <[email protected]> wrote: > 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 < > [email protected]> 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 >
