I have the following situation:
- a column of type multiple select
- some possible values amongst which a value with a comma in it
When exporting to CSV, in the CSV file itself, that value appears wrapped by three double quotes, like this:
“”“this, that”""
which according to the CSV RFC, means that the value in that field is “this, that” (including the surrounding double quotes), as double double quote is the escape of the actual double quote. What I want is the value this, that (without surrounding double quotes).
I have read "Unwanted Quotes" in CSV , but there seems to be a special issue with the multiple select column where the double quotes are added twice, it behaves differently than for a simple regular text column.