I really want to use Airtable for Data Entry but have the following problem. I’m not very technical so any replies should reply to me like I’m 5.
- Airtable exports CSV with comma separated values.
- The third party database I’m importing into only accepts semi colon separators.
How do I transform the comma separators into semi-colon separators?
I have access to both a PC and a Mac.
I live in Australia where we use commas as currency decimal separators in our system settings.
I tried just find/replace of the commas with semi-colons but of course this replaces all my non-separator commas in paragraphs into semi-colons.
I thought maybe I could put my paragraphs in Airtable between quotation marks and then somehow use something to say “whenever there’s a comma inside a quotation mark, don’t replace it with a semi-colon.” But I don’t know how to do this. Anyone have any suggestions?