Skip to main content
Soph1997
Mar 12, 2023 5:19 PM UTC
Solved

How to remove double quotes from extract .CSV file

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

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ParthaSarathy
ParthaSarathyAccepted solution
Community Advisor
Mar 13, 2023 5:44 AM UTC

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

 

 

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
View in thread

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
Mar 13, 2023 5:44 AM UTC

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

 

 

Translate
~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Soph1997Author
    Mar 14, 2023 2:25 AM UTC

    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

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...