How to remove double quotes from extract .CSV file

[Soph1997]

Hello campaign experts, I'm trying to load a .CSV file produced by Adobe campaign extract process then load it into an Oracle table via SQL Loader utility but running into challenges populating the table with "" strings in fields. the extract file produce fields with a set of a double quotes around it.

Current output .CSV data:

"njpottery@yahoo.com","03/09/2023 09:00:45","712405,03/09/2023 09:00:45","Y"

Desired output .CSV data:

njpottery@yahoo.com,03/09/2023 09:00:45,712405,03/09/2023 09:00:45,Y

Any suggestion on how to achieve the desired output result is greatly appreciated.

Thanks,

Sof

[ParthaSarathy · Accepted solution]

Hi @Soph1997 ,

You can try this approach,

Define the file name as .csv in data extraction activity

Click on 'Edit the file format' and navigate to 'Destination Format' and configure as below

So the output file will be a .csv file, and string values will have no delimiter

[Soph1997]

Hi Partha, Thanks for suggested approach. It's working as intended and was able to load the data into a external oracle table with the format produced.

Thanks,

Soph