Post AS8yMTLPJqhTTkMtO4 by berkes@bitcoinhackers.org
 (DIR) More posts by berkes@bitcoinhackers.org
 (DIR) Post #AS8Gw7G6VvwxQK4cz2 by berkes@bitcoinhackers.org
       2023-01-28T18:34:38Z
       
       0 likes, 0 repeats
       
       In Dutch, and some other European locales, decimals are written with a comma: €13,37 is thirteen euro thirty-seven cents. 112,345 g is hundred twelve gram, not hundreds of thousands.With CSV Import and export, it's a random chance what format you get. This has caused me so much trouble, time and money. For decades, people have felt this issue, and it's still not solved. Not even seen, by many devs from places where this issue doesn't occur.Sure. I have sed&awk. But that's a kludge. #rant
       
 (DIR) Post #AS8Gw7mMZzkp2NAOGW by vfrmedia@social.tchncs.de
       2023-01-28T18:38:45Z
       
       0 likes, 0 repeats
       
       @berkes I've noticed some CSV files generated from European countries where this occurs (or from equipment designed in these countries) often use a semicolon as a delimiter in place of the comma - I once had a SAGEM mobile phone from France which did this.Newer versions of Excel have ways of dealing with it (provided you check the input file first to see exactly what you have - I noticed this in passing when coding some VBA this week)..
       
 (DIR) Post #AS8Gw8KOXSyajv5ZJI by berkes@bitcoinhackers.org
       2023-01-28T18:50:18Z
       
       0 likes, 0 repeats
       
       @vfrmedia excel and libre calc have tooling to help, with this, indeed. In Google sheets, there are workarounds. All require vigilance, though.Worse is with online imports and tools. Or with more obscure data tools. "Huh? Why are generating thousands of products? Half an hour searching later: Ah, 178.00 is seen as 17800." Me, a week ago.
       
 (DIR) Post #AS8Gw8kGzFg02BCEe8 by vfrmedia@social.tchncs.de
       2023-01-28T19:01:19Z
       
       0 likes, 0 repeats
       
       @berkes interestingly I once read a safety paper from the British Oxygen Company which recommended (even in UK) using the decimal comma and a space to separate digits in large numbers (eg 1 000 kg), especially for international readers, which I also tend to do on the Fediverse as so many of my followers are in countries that use the decimal comma. I think BOC have the right idea, as they deal with a lot of stuff where you really do *not* want to make any mistakes..
       
 (DIR) Post #AS8Gw9BZLlVjOpy2C0 by matt@oslo.town
       2023-01-29T10:29:00Z
       
       0 likes, 0 repeats
       
       @vfrmedia @berkes This confuses me from time to time. Growing up in the UK, I always learnt to put commas between the thousands and a period before the decimals (199,999.01)But in Norway they would write it with a space between the thousands and a comma before the decimals (199 999,01)So when I encounter any web form it's a guessing game of what format they follow. I usually try inputting with no spaces between the thousands and period for decimals (199999.00)
       
 (DIR) Post #AS8yMTLPJqhTTkMtO4 by berkes@bitcoinhackers.org
       2023-01-29T18:35:35Z
       
       0 likes, 0 repeats
       
       @matt ah, yeah. Webforms are horrible for this too.And the HTML5 <input type=number> has only made it worse, IMO. I've even encountered a website where I had to change the locale of my browser, because some backend refused the decimal without comma, it got from My Firefox, but Firefox refused a number with a comma in it's locale.