How to mention text enslosure in tfileoutputdelimited
Hello All,
I have a scenario where Im loading data from source oracle table to csv output. The delimiter Im using in csv output is ;
My source data conntains commas in it and hence im using CSV options. But when Im using the CSV options, the data in the file is enclosed in double quotes because in text enclosure I used "\"" . But can some one please help me understand what to mention in text enclosure so that my text is not enclosed in double quotes.
My Source Data. Please see Table.PNG attachment.
Please see csv.PNG image of how i used CSV Options.
I have also attached how my output looks like. I want to remove the double quotes around the data.
Without double quotes value: "Brad,is a male" will be treated like two columns, because your field delimiter is comma (,). You wrote that this is ; but your example tells something diffrent 😉 I don't know who and how will use the output file, but turning off double quotes may complicate some other file transformations.
