how to putting double quotes around all the data fields in a csv file.

Four Stars

how to putting double quotes around all the data fields in a csv file.

Hi,

 

I am doing a select on a table from oracle database and placing that in a csv file. i want to put double quotes around all the data fields .

 

can someone tell me how to do this.

 

Thanks

spallapu

Accepted Solutions

Re: how to putting double quotes around all the data fields in a csv file.

Hi,

best to create metadata for your file delimited and configure Text enclosure settings as :

 


2018-03-09 17_36_55Metadata csv.png2018-03-09 17_38_40 escape Quote.png

 

BR Bp

Forteen Stars TRF
Forteen Stars

Re: how to putting double quotes around all the data fields in a csv file.

text enclosure

TRF

All Replies
Forteen Stars TRF
Forteen Stars

Re: how to putting double quotes around all the data fields in a csv file.

Hi,

tFileOutputDelimited advanced setting then tick CSV options.


TRF
Four Stars

Re: how to putting double quotes around all the data fields in a csv file.

I see two options escape char and text enclosure with the default values as """.

 

which one do i have to change to get double quotes around each data field.

spallapu

Re: how to putting double quotes around all the data fields in a csv file.

Hi,

best to create metadata for your file delimited and configure Text enclosure settings as :

 


2018-03-09 17_36_55Metadata csv.png2018-03-09 17_38_40 escape Quote.png

 

BR Bp

Forteen Stars TRF
Forteen Stars

Re: how to putting double quotes around all the data fields in a csv file.

text enclosure

TRF
Four Stars

Re: how to putting double quotes around all the data fields in a csv file.

yes that worked . Thank you for ur help Smiley Happy

spallapu
Forteen Stars TRF
Forteen Stars

Re: how to putting double quotes around all the data fields in a csv file.

Hi,
Don't forget to mark your case as solved.

TRF