Goal - I have a scenario where I pull out Shopify order information add them to a CSV file and upload that file to an FTP server. However all the Shopify informations get added with a double quotation mark to the CSV. This is causing issues with the system that uses the file on the FTP.
I try to remove the quotation marks in the CSV by using the Replace Text Parser Module but it seems like the quotations are part of the CSV text and I’m stuck on how to remove the quotations.
I’m also quite new to Make.com and would really appreciate some help.
Hi @Sarah_Stimpfl,
Quotes are around each field in case the field’s value contains commas or double quotes. Without the double quotes around the field value it would be hard to distinguish when a comma is separating two values or part of the value.
I think your best bet is to find out why the service that uses CSV doesn’t accept double quotes around the fields as it’s a pretty common practice.
If you can guarantee the values won’t contain commas or double quote characters, one option you have is to simply use the replace() function to replace all quotation marks with an empty string and you won’t need to use the Text Parser module.
Something like this:
replace(CSVdata;";{{emptystring}})
If you want to use Text Parser Replace, you can use something like " for the pattern (find all double quotation marks), then for New Value use {{emptystring}}. Global match should be set to Yes for this to work.
Again, if any of your values contain commas or double quotes, this will not work.
3 Likes
