How to change the delimiter when exporting CSV from Excel?

Recently, I needed to find a way to import data from an Excel to a custom-coded system that could import CSV files. However, the data was fairly unsanitized – containing commas, semicolons and other weird characters. I could define the delimiter used in the imported data – however, to do that, I needed to also be able to define it in the export. What’s a “CSV” -file ? Stands for “comma-separated values” – A text file that uses a comma to separate values. Each line…Continue reading How to change the delimiter when exporting CSV from Excel?