3 ms·
Not sure if they still do this, but Klarna would send us ", " separated files. If there wasn't a space after the comma then it was to be read as a decimal point
by mrweasel 2y ago
Not sure if they still do this, but Klarna would send us ", " separated files. If there wasn't a space after the comma then it was to be read as a decimal point. Most of the CSV parser don't/didn't allow you to specify multi-character separators. In the end I just accepted that we had one field for krona and for öre and most fields would need to have a leading space removed.
- raxxorraxor 2y agoMicrosoft did this very extensively. Many Non-English versions of Excel do save CSV-files with a semicolon as a separator and it probably was handled differently too in normal Excel files. But it goes even further, it affected their scripting languages even to this day with newer languages like their BI script (forgot the name of the language). For example, parameters of function calls aren't separated by ',' anymore and ';' is used instead. But only in the localized versions. That of course means that you have to translate these scripts depending on the locale set in your office suite, otherwise they are full of syntax errors...
- oddmiral 2y agoMany English languages use ';' to end statements instead of '.'. Many European languages use '.' to end statements, Prolog (France) for example, but use ';' to separate arguments.