Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

How to remove double quotes from extract .CSV file

Avatar

Level 1

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

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Soph1997 ,

You can try this approach,

Define the file name as .csv in data extraction activity

Partha_Sarathy__0-1678685982838.png

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

Partha_Sarathy__1-1678686069840.png

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

Partha_Sarathy__3-1678686217821.png

 

Partha_Sarathy__2-1678686140089.png

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi @Soph1997 ,

You can try this approach,

Define the file name as .csv in data extraction activity

Partha_Sarathy__0-1678685982838.png

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

Partha_Sarathy__1-1678686069840.png

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

Partha_Sarathy__3-1678686217821.png

 

Partha_Sarathy__2-1678686140089.png

 

Avatar

Level 1

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