9
2
I have an Excel file with Unicode content of which some cells contain text inside double quotes, for example "text"
.
When I save the Excel file to a text file in Unicode format, the text which contains the double quote is saved as three double quotes, for example """text"""
.
There are some places where I even have text which contains comma (,). For example, text,
which is converted into "text,"
in the Unicode file. It is adding double quotes to the text, which I guess contains special characters.
How can I avoid this?
@slhck: I am facing issue while saving Unicode as CSV in 2010 https://superuser.com/q/1210099/234380
– NJMR – 2017-05-18T05:13:35.4802You mean that there is no other way to solve the issue other than replacing them in text editor. – karthik – 2011-10-24T13:01:18.390
Not really, since Excel has to do it for compatibility reasons. Maybe it might be possible to come up with a Macro that does a custom export, but I'm no expert on this. – slhck – 2011-10-24T13:09:11.210
Ok thanks may be i will try to replace it in the coding side. – karthik – 2011-10-24T13:15:50.600