this post was submitted on 26 Dec 2024
102 points (98.1% liked)

chat

8246 readers
293 users here now

Chat is a text only community for casual conversation, please keep shitposting to the absolute minimum. This is intended to be a separate space from c/chapotraphouse or the daily megathread. Chat does this by being a long-form community where topics will remain from day to day unlike the megathread, and it is distinct from c/chapotraphouse in that we ask you to engage in this community in a genuine way. Please keep shitposting, bits, and irony to a minimum.

As with all communities posts need to abide by the code of conduct, additionally moderators will remove any posts or comments deemed to be inappropriate.

Thank you and happy chatting!

founded 3 years ago
MODERATORS
 

My reasoning is that the period is a "stronger" punctuation mark than the comma, and it should be used for the more important separation.

https://en.wikipedia.org/wiki/Decimal_separator

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 1 points 1 day ago* (last edited 1 day ago) (1 children)

I wouldn't use excel as an example, it's most likely going to interpret it as a date no matter what you type

I mentioned excel because it's been my arch enemy for the past 3 years to the point where I had to spend a substantial amount of time writing my own library for reading excel files maddened The thing I'm specifically talking about is how formulas may look different across localizations. For example the sum function looks as follows in english:

=SUM(1,2,3)

while in russian it looks like this:

=СУММ(1;2;3)

and excel will not allow you to type the english version

This brought back my biggest grievance with parsing numbers, chat apps interpreting any 5+ character long numbers as phone numbers

No, I don't want to call 10.000

funnily enough, phone number parsing is one of my previous arch enemies. Having to turn whaterver bullshit user has typed into a phone number probably reduced my life expectancy by several months

[–] [email protected] 1 points 1 day ago

I feel you, I nowadays prefer doing the calculations in python and export the results in .csv for the freaks who prefer excel

funnily enough, phone number parsing is one of my previous arch enemies. Having to turn whaterver bullshit user has typed into a phone number probably reduced my life expectancy by several months

This reminds me of my futile attempts of parsing URLs with regex in my teenage years when I was trying to make a guestbook for my website with PHP (the solution is .*\..*)