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.
"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
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.