I receive a CSV file from sever. The data inside it is delimited by semicolon and it is in UTF-8 format.
For example, the data what we receive is:
"NL 我喜"" mutilple""我喜"
When we open it for the first time in
Excel 2010, it will show as
NL 我喜" mutilple"我喜
But when I modify (I just removed the letter L from the above text) this file and save it as CSV using excel and open it for the second time, it will look like
N inbetween我喜 (without double quotes)
I want the data after modification to be saved with double quotes.