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.
Mar 01, 2022 07:56 AM
I would suggest emailing support@airtable.com with this feature request!