Do you need a controller for that? I thought just a GetFile pointed at a directory would suffice.
On Tue, Sep 17, 2019 at 5:54 PM KhajaAsmath Mohammed < [email protected]> wrote: > 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 >> > -- Eric Ladner
