After we exported the report as a CSV file, Qualtrics changed single quote or double quotes into some strange symbols. Can you please fix that? Thank you very much!
The “Title†will be more effective than other vacuums in cleaning my carpet and hard surfaces.
It should be this way:
The “Title” will be more effective than other vacuums in cleaning my carpet and hard surfaces.
------------------------------
The “Title’s†no touch disposal system is a strong reason to buy the product.
It should be this way:
The “Title’s” no touch disposal system is a strong reason to buy the product.
Solved
Single Quote or Double Quotes in a CSV File
Best answer by TomG
It's because your quotes aren't the quotation mark character (U+0022), but extended left quotation mark (U+201C) and right quotation mark (U+201D) characters. You should replace the left/right quotation marks with a regular quotation mark.
+27It's because your quotes aren't the quotation mark character (U+0022), but extended left quotation mark (U+201C) and right quotation mark (U+201D) characters. You should replace the left/right quotation marks with a regular quotation mark.
We used the the quotation marks in Qualtrics when we set up the survey. So Qualtrics could not recognize its own quotation marks when it exported the report as a CSV file?
+27CSV doesn't support unicode characters. Export as TSV instead.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.