I have 2 spreadsheets (saved as csv files) which contain text elements with apostrophes. In one file the apostrophe is saved as a single ‘character’ hex 27, whereas in the other file the apostrophe is saved as 3 ‘characters’ hex E2 80 99. What do I need to change so that both files save in the same way?
The second character.
.
If you google the codes one is your old typewriter single quote, the other is a typographic variant of a pair opening/closing single quotes. They can look quite similiar (depending on fonts), but they are different characters.
.
My first google hit:
https://www.cogsci.ed.ac.uk/~richard/utf-8.cgi?input=2019&mode=hex
1 Like
Thank you. I still don’t know how to change the file. Deleting and retyping the character doesn’t seem to have any effect.
Both files were created using Libreoffice calc and all apostrophes have been typed using the same character on my keyboard. I may have created the files in slightly different ways - one may have been saved originally as part of a large spreadsheet with several sheets (an ods file) and then an individual sheet saved and the other may have been created from this or another csv file by deleting and retyping some fields.
Is there some setting that must be different between the 2 files which means they save in different ways?
For normal input the 'single quotes' are replaced by the setting in ⇒ Tools ⇒ Auto-Correct-Options ⇒ Localized Options ⇒ Single quotes
this may not happen for copy&pasted data?
I don’t really recommend this, unless you know what you do.:
I assume you saved your .csv with utf8-charset.
If you select an old 8bit charset like DOS/OS-2-437/US the typographical quotes are converted.
Then import back.
.
You may loose not available characters, so above is dangerous.
Thank you karolus. I have now changed my settings so that I get the basic apostrophe when I press the single quote key.
When you save as CSV, there is an option at the bottom to ‘Edit filter settings’ there you can change the Character set