5 ms·
Can you also set the decimal separator? Some countries use ',' in numbere like 10,5
by andi999 4y ago
Can you also set the decimal separator? Some countries use ',' in numbere like 10,5
- ta8645 4y agoCan 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.
- bloak 4y agoSomebody 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 '·'.
- Frost1x 4y agoWhat, 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?
- franga2000 4y agoExactly. 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).
- Chris2048 4y agoDoh, 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).
- gpvos 4y agoWhat 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.
- gmfawcett 4y agoYou 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." :)
- gpvos 4y agoI'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.
- planede 4y agohttps://en.wikipedia.org/wiki/Decimal_separator#Digit_grouping https://en.wikipedia.org/wiki/Decimal_separator#Digit_groupi... They use spaces or dots.
- slightwinder 4y agoYes, 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).
- Hackbraten 4y agoGermany 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?
- bmacho 4y ago" Why would we, anyway? " To be compatible with the world, so Germans can use international software, and could sell software to international people.
- Mordisquitos 4y agoCall 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.
- CRConrad 4y agoAnd 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?
- gpvos 4y agoAmerica 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.
- slightwinder 4y agoThere are more countries using the comma than the dot. Why should the majority follow a minority in that case?
- alisonatwork 4y agoAre 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.
- slightwinder 4y agoYes, but does the number of people matter in that case?
- alisonatwork 4y agoIf 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.
- slightwinder 4y agoNo, 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.
- alisonatwork 4y agoYou 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.
- gpvos 4y agoNo. 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.
- Findecanor 4y agoIt is not a matter of what I use. It is a matter of what the data uses.
- otikik 4y agoIn my country (Spain) we traditionally use commas as a decimal separator, but I think CSV should not support this. The way I see it, CSV's purpose is information storage and transfer, not presentation. Presentation is where you decide the font face, the font size, cell background color (if you are viewing the file through a spreadsheet editor) etc. Number formatting belongs here. In information transfer and storage it's much more important that the parsing/generation functions are as simple as possible. So let's go with one numeric format only. I think we should use the dot as a decimal separator since it's the most common separator in all programming languages. Maybe extend it to include exponential notation as well, because that is what other languages like json support. But that's it. I hold the same opinion about dates tbh. (The same goes for dates, btw - yyyy-mm-dd or death)
- hedora 4y agoFor time formats, use ISO 8601, and be sure to append a Z to the end to denote UTC (zulu time), and consider rejecting timestamps without it: https://en.m.wikipedia.org/wiki/ISO_8601 https://en.m.wikipedia.org/wiki/ISO_8601 The only real problem with that format is the distasteful "T" in the middle (but, hey, at least it is whitespace-free!)
- j0057 4y agoThe other distasteful thing is getting your hands on the actual ISO 8601 specs is pretty expensive, like 350 CHF, which is weird, because so many national standards bodies gave it official blessing, and so many things in the digital universe depend on it. Maybe that 'T' is optional after all!
- denisw 4y agoThere is RFC 3339, which is essentially “ISO 8601: The Good Parts” and, like all IETF RFCs, freely available: https://www.rfc-editor.org/rfc/rfc3339 https://www.rfc-editor.org/rfc/rfc3339
- andi999 4y agoWhat do you mean by csv shd not support this. Do you mean it was a historical mistake or new parsers shdnt be able to read it?