[ferret_users] CSV file with commas in string fields

[Marco van Hulten <Marco.Hulten@xxxxxx>]

Hello,

I load CSV files that sometimes have commas in some string fields.
According to, for instance, RFC 4180, at least the string fields with
commas should be surrounded by double-quotes, so, for instance:

"st1",2,3
"st1,2",2,3
st2,2,3

This fails when trying to load with COLUMNS: the comma between
double-quotes is treated as a field-separator.

Two options are (1) using a different field separator (e.g. the tab
character) and (2) remove/replace the commas, but I prefer to avoid
reformatting of the CSV data.

Any additional ideas?

—Marco