News for hackers. Stuff that matters.
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by ta8645 on Thursday May 12, 2022 @06:18AM (#31351752)
Can we please, please, stop that? If we go Metric, will you please standardize on period as decimal point? Shake on it. Let's make it happen.
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by bloak on Thursday May 12, 2022 @06:54AM (#31352115)
Somebody told me that the official international standard prefers comma; a period is just a permitted alternative. Of course, comma as decimal separator isn't very compatible with programming languages.

However, the decimal separator that I was taught at primary school and have used in handwriting all my life is neither comma, nor period, but '·'.

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by Frost1x on Thursday May 12, 2022 @07:03AM (#31352199)
What, why? I've seen comma decimal separated values but I thought it was a weird English thing. What do these places use to separate larger values (e.g. each 10^3 magnitude increase) to make manual counting easier.

828.497.171.614,2?

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by slightwinder on Thursday May 12, 2022 @07:30AM (#31352423)
Yes, using a dot for grouping is a common solution. But it seems to be fading out because of the conflict. Other solutions are a space (12 345,67) or apostrophe also known as "highcomma" (12'345,67).
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by franga2000 on Thursday May 12, 2022 @07:21AM (#31352345)
Exactly. The "official way" of writing big numbers around here (I know at least the balkans, germany and austria) is `1.000.000,00 €` (1 million). So what you wrote, but always at least 2 decimal places (or zero if it's not a financial document).
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by Chris2048 on Thursday May 12, 2022 @07:34AM (#31352452)
Doh, Having two opposite conventions is a PITA.

But if I add my 2 cents - I prefer 1,000.00 because I think it is similar to commas and full-stops in writing, where a comma is mainly a reading/speaking guide to help break up a sentence (or in this case a number) and a full stop is a much harder termination of a sentence (in the case of a number the official origin where int/non-fractional part ends).

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by gpvos on Thursday May 12, 2022 @09:20AM (#31353725)
What is worse is the ignorance on the English-speaking side. We have been putting up with your stuff for a few decades now, and almost the entire population needs to know about it, while we see near-zero attempts to adapt from your side.
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by gpvos on Thursday May 12, 2022 @09:22AM (#31353755)
I'd argue the decimal separator is more important and should therefore be more visible; the comma is larger than the dot and extends below the baseline so is easier to see.
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by gmfawcett on Thursday May 12, 2022 @08:17AM (#31352898)
You could argue that both ways. "Here's a big amount. That's a moderate amount. And that is a small amount, with a tiny extra bit." :)
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by planede on Thursday May 12, 2022 @07:11AM (#31352267)
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by Hackbraten on Thursday May 12, 2022 @06:59AM (#31352166)
Germany has been metric forever but has the comma as a decimal separator, and the dot as a thousands group separator. It’s deeply engrained in our typography, it has typographical idioms such as ,— (comma em-dash), up to the point that even brands have adopted it in their brand name.

I’m afraid we can’t really change that on a whim. Why would we, anyway?

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by bmacho on Thursday May 12, 2022 @08:55AM (#31353380)
" Why would we, anyway? "

To be compatible with the world, so Germans can use international software, and could sell software to international people.

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by gpvos on Thursday May 12, 2022 @09:50AM (#31354147)
America is not the world; at least in the western world[0] there are more countries and languages that follow the German convention. Also, there is more to the world than software (although that seems to be changing).

[0] Yes, that shows my limited perception.

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by Mordisquitos on Thursday May 12, 2022 @09:19AM (#31353717)
Call me crazy, but I'm under the impression that Germans do use international software, and that Germany may even be home to the fourth largest software company in the world.
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by CRConrad on Friday May 20, 2022 @07:29AM (#31445928)
And in a largely successful attempt at German self-parody, that software is hugely complex and laborious; in short, over-engineered.

It is the only software I know of where you regularly hear of "implementation" -- which in this context means installing the software, not writing it -- projects being planned to take years, actually taking twice as long, and sometimes being abandoned altogether when the prospective client finds out it just can't be done.

I mean, it is SAP you're talking about, right?

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by slightwinder on Thursday May 12, 2022 @07:32AM (#31352434)
There are more countries using the comma than the dot. Why should the majority follow a minority in that case?
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by alisonatwork on Thursday May 12, 2022 @09:02AM (#31353488)
Are you certain that more people, numerically speaking, use the comma as a decimal separator? India and China do not, although admittedly India has another decimal grouping system.
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by slightwinder on Thursday May 12, 2022 @11:16AM (#31355409)
Yes, but does the number of people matter in that case?
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by alisonatwork on Thursday May 12, 2022 @11:59AM (#31356013)
If we are aiming to create a common international system of representing the fractional part of a decimal number, it makes sense to start with the system that is already in use by the most people.
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by slightwinder on Thursday May 12, 2022 @04:36PM (#31359870)
No, it does not. The Countries individual choice has more weight than their number of citizens. It's probably also more work to change laws and regulations, than letting people adapt to the changes.

This is basically the classical problem of democratic systems, when they need to balance the interests of different sized groups. Numbers alone don't make a fair solution. And unless you have the power to force them, you will not convince everyone to follow you just by arguing with numbers anyway.

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by alisonatwork on Friday May 13, 2022 @06:37AM (#31365609)
You are the one who proposed that the majority should not follow the minority, but now you are also saying that the minority should not follow the majority either. If your point is that nobody should follow anybody because freedom is more important than standardization, that's fine, but then it would have been clearer to just say that in the first place.

In my opinion, when we are talking about a data interchange format like CSV, having a simple, common format would be far more practical and efficient than allowing each country to decide for itself its own standard. Having dealt with exactly this problem in a global SaaS product where a minority of clients submitted CSV files with commas for decimal separators, I can say it would have made the parsing code a lot simpler and more robust if our system (and countless others like it) did not need to build in exceptions for this minority use case.

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by gpvos on Thursday May 12, 2022 @09:17AM (#31353698)
No. I agree it should be universally used for machine-readable data formats, but for human consumption there is no need to be anglo-centric.

You guys are already slowly encroaching on milliards and billiards in other languages with your illogical short scale numbers.

Re:Modernizing AWK, a 45-year old language, by adding CSV su... by thechao on Thursday May 12, 2022 @09:34AM (#31353908)
Don't worry, some of us are still fighting for the gloriously base-2 US customary system; base-10 is only for people who don't float. And the 30cm foot.
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by gpvos on Thursday May 12, 2022 @09:42AM (#31354023)
Well, in a way a base-2 system would have been far ahead of its time... it's not consistently base-2 though.
Re:Modernizing AWK, a 45-year old language, by adding CSV su... by Findecanor on Thursday May 12, 2022 @10:17AM (#31354575)
It is not a matter of what I use. It is a matter of what the data uses.