'Saving xlsx file in csv tranform simple quote to triple quote (since today)
Since today, excel interprets the data of my xlsx file to add additional quote in the csv file. It's anonying since I want only one quote for some columns and none for others.
I didnt have this problem before.
For instance : text1;"text2" becomes text1;"""text2"""
I know that I can replace the triple quote in the output file with one quote, but cant I desactivate an option or whatever to avoid this ?
In the same way, when I save in csv file data which has been interpretaed by excel (like cells in number format instead of standard), the csv file keeps the excel format instead of saving sourcing data. For example, 0 is "-" in number format and is saving as " - " in csv file instead of "0".
Thanks for helping :)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|