Can someone point me to what is the best method of importing CSV files into Tapforms where the data maintains a consistent field format but may contain delimiter’s within the text being imported? Ideally I would also like to be able import hashtags against the files as well.
Thanks in appreciation of you feedback.
Hi Peter,
If your text contains the delimiter, then the CSV file must have double-quotes around the values.
So the CSV file would have to be like this:
Book Title,Author
Nobody’s Business,”Duddridge, Linda”
So even though the delimiter is a comma, the Author value also has a comma, but within the content, but it’s quoted, so Tap Forms treats “Duddridge, Linda” as a single value.
I don’t see why hashtags would be an issue. It’s just a text value with a pound symbol.
Thanks,
Brendan
.
