Remove quotes from CSV export set

Julie Gordon · ‎10-18-2023

I've seen similar posts, but haven't found an answer.

I have an Export Set that sends a .CSV file to our Mid Server. Works beautifully. But the requirement put upon me is to remove the double quotes(" ") from each field, so it ends up as a purely comma delimited CSV file.

Current file displays: "Julie", "Gordon", "Company"

Preferred file display: Julie, Gordon, Company

I'm thinking it has to be a pre-export script, but I'm newish to scripts & even newer to APIs. Usually I can Frankenstein something together from prior posts, but would appreciate any help anyone can offer.

Julie Gordon · ‎10-24-2023

Anvesh- Thank you for your reply! I had found that article, but it did send me down a different path. Ultimately here's my solution.

1. Export Set to MID server

2. Symbolic link from MID server location to Network location(my requirement; also on my MID)

3. MID server script file as an attachment = powershell to take the CSV on the MID, remove quotes & replace.

4. Post Export Script on the Scheduled Export Set to trigger the powershell on the MID to run.

View solution in original post

narayansaha · ‎07-24-2024

Hello Julie,

Hope you are doing well, I have come across to your solution in search of a similar use case which I am trying to implement, removing the double quotes from a csv file exported into our MID Server.
I have tried following your solution but unfortunately I am still unable to fix the double quotation issues.
It would be very helpful, if you could please verify the below steps I am doing and let me know, in case if I am missing anything or doing a mistake.

Step1: I have written the below powershell script in our MID Server:
image (6).png

Step2: Saved the Powershell script:
image (5).png

Step3: I have updated the Scheduled Data export, post-export script:

But the double quotes is still there:
image (3).png

Best Regards,
Narayan Saha