Oct 17, 2024 01:01 AM
Hello,
@ScottWorld, after watching one of your videos, I set up a Make scenario to automate a csv export from an Airtable view:
I used the CSV "create csv advanced" module and it works fine.
My problem is that all fields in the exported csv are surrounded by double quotes:
Do you know how I can remove them?
Thank you
Pascal
Solved! Go to Solution.
Oct 17, 2024 05:17 AM
Hi @Pascal_Gallais- ,
CSV files always add quotes around values that have spaces or other special characters in them, but I’m not sure why Make puts quotes around 100% of the values… even if those values don’t have spaces or special characters.
However, you don’t really need to worry about the quotation marks, because any database or spreadsheet program that imports the CSV file should know to remove the quotation marks upon importing.
A text editor will show you the raw data with quotation marks, but any program that imports the CSV file should ignore the quotation marks.
If you use a different method to create the file like using the text aggregator that @dilipborad mentioned above, be aware that you might accidentally be removing quotation marks where they actually SHOULD exist in a CSV file.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Oct 17, 2024 02:29 AM
Hello @Pascal_Gallais-,
While you use Make there are lots of options but in your case.
Try to use Text Aggregator and then set up a variable for headers of csv.
Output
You need to make sure to use your all variables and give a proper header if it's required.
Another important thing is that most CSV are surrounded with "(quotes) because sometimes the comma(,) is used within some of the values and at that time all csv goes messed up. So you need to remember this.
Hope this works for you.
👍
Oct 17, 2024 05:17 AM
Hi @Pascal_Gallais- ,
CSV files always add quotes around values that have spaces or other special characters in them, but I’m not sure why Make puts quotes around 100% of the values… even if those values don’t have spaces or special characters.
However, you don’t really need to worry about the quotation marks, because any database or spreadsheet program that imports the CSV file should know to remove the quotation marks upon importing.
A text editor will show you the raw data with quotation marks, but any program that imports the CSV file should ignore the quotation marks.
If you use a different method to create the file like using the text aggregator that @dilipborad mentioned above, be aware that you might accidentally be removing quotation marks where they actually SHOULD exist in a CSV file.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Oct 17, 2024 06:12 AM
Thanks @ScottWorld , that's very clear
Dec 08, 2024 11:58 AM
Hi, I am a bit late to the topic, but there's a lot of customization options with respect to CSV exports with the Data Extraction extension: https://airtable.com/marketplace/blkiQT71Vaz7uwi5j/data-extraction
Different kind of quotes, escapes and more