Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Mar 01, 2022 02:38 AM
When importing a CSV with a multi-select column, Airtable will always detect commas as a separator and make tags from it. But in my case the tags contain commas I don’t want to have as a separator.
Do you know any workaround to either avoid thos specific commas to be detected as a separator, or change the separator character ?
Thanks !
Solved! Go to Solution.
Mar 01, 2022 04:05 AM
Try importing the phrases (with quotation marks) into a normal text field first, and then convert the text field into a multi-select field afterwards. See if that works.
Mar 01, 2022 02:40 AM
Before importing, try putting quotation marks around the phrases that contain commas.
Mar 01, 2022 02:54 AM
Thanks for your answer.
Already tried this and it didn’t work…
Mar 01, 2022 04:05 AM
Try importing the phrases (with quotation marks) into a normal text field first, and then convert the text field into a multi-select field afterwards. See if that works.
Mar 01, 2022 07:43 AM
It works !
Thank you for your answer it will be sufficient for my need for now… It’s not very comfortable though. Maybe if we could choose the separator between “;” or “,” (as they are both used is CSV) it would make the import feature easier to use… Or at least having the same splitting method between import and update…
Thx again.