I am trying to figure out how to export the results of a query into a database table when that data contains quote characters. This is my data:
id | token | country
When we export as a CSV, the lone quote causes the entire file to be messed up from there on.
In the Configure CSV Formats screen, Quotation: " " Escape: duplicate is set.
It seems like this should be a fairly straightforward process. What additional settings do I need to make to be able to export a CSV in valid format?