I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote.
Example:
"col1","col2","col3"
"01","text","<html><tag attrib="true">"
I decided to use another character as text qualifier, the backtick ` which is never present in my original file.
My data are like this now:
`col1`,`col2`,`col3`
`01`,`text`,`<html><tag attrib="true">`
Now my CSV is totally valid, but in Excel (2013) I cannot just change the Text Qualifier, it allows me only "
, '
or {none}
Is there any way to edit this list to add a new text qualifier?
I finally found another way to import it but I am just wondering why the Text Qualifier
box is not editable.