How to remove double quotes from extract .CSV file | Community
Skip to main content
S
Soph1997
March 12, 2023
Solved

How to remove double quotes from extract .CSV file

  • March 12, 2023
  • 1 reply
  • 1363 views

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.
Best answer by ParthaSarathy

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

 

 

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
March 13, 2023

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
    S
    Soph1997Author
    March 14, 2023

    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

      Terms & ConditionsAccessibility statement

      Loading footer...