I want to import a lot of text in Adalo database with CSV import function.
Unfortunately in the text, there are commas…
Is it posible to tell adalo to use another symbol instead of comma ?
Or is it possible to tell adalo the commas are the text and not commas for the CSV. For exemple with “,” or with ,.
If I have 2 text fields of text.
For example in the cv:
Word 1, word 2, word 3, word 4
It may be understood by Adalo:
Text 1: Word 1
Text 2: word 2, word 3, word 4
Or
Text1: Word 1, word 2
Text2: word 3, word 4
Or
Text1: Word 1, word 2, word 3
Text2: word 4
In my example with these 4 words and commas. If I have only 2 text fields, how Adalo will understand the csv :
Word 1, word 2, word 3, word 4 ?
And how to change its understanding if I need to. For example if Adalo use the first coma to separate the field 1 and the field 2 (so field 1 would be « word 1 » and field 2 would be « word 2, word 3, word 4 ») but I wanted the field 1 is « word 1, word 2 » and the field 2 is « word 3, word 4 ».
Adalo understands the comma after « Hello » like the end of the field. And so « I am fine » is another field.
How to tell Adalo it’s not a comma for separation but it’s the same field ?
Once you add hello,I am fine in the CSV and upload it on Adalo you don’t get the comma? Is it possible to explain this from a video showing the CSV and the setup?