Friday, 28 February 2014

Export csv files separated by semicolons

When you try to export files from Excel after manage them, you could see that even if you choose .csv format data has been divided by semicolons instead of commas.
This could be caused by regional settings.
Change the list sepearator in Formats-Additional settings within Region(Windows8) or Regional(Windows7) settings from semicolon(;) to comma(,) and decimal symbol from comma(,) to dot(.).
If you need to have decimal symbol as comma, then Excel will still export .csv files with semicolons.
I've found small script which does resolve problem in this case
You can create new macro in Excel, put this script inside, and run macro when your file is ready to be saved.
I will post the script soon




No comments:

Post a Comment