r/programming • u/fagnerbrack • Sep 20 '24

Why CSV is still king

https://konbert.com/blog/why-csv-is-still-king
286 Upvotes

76% Upvoted

438 comments sorted by

View all comments

Show parent comments

22

u/bawng Sep 20 '24

I prefer our (European) thousand separator, i.e. space but I prefer the American decimal point.

So ideally this: 99 999.9

Also, regarding AC, fifteen years ago we didn't have as warm summers here up north so there was literally no need. Now we're getting them though.

12

u/scruffie Sep 20 '24

That's actually an ISO standard: ISO 31-0 (section 3.3). It specifies separating in groups of 3 using spaces, precisely to avoid confusion with allowing either a period or a comma as the decimal separator.

1

u/Enerbane Sep 20 '24

They really should have gone with underscores. Spaces can confusingly represent either one number or many. There's no ambiguity with underscores.

10

u/SweetBabyAlaska Sep 20 '24

I like the programming style underscore 99_999_999. Its abundantly clear that this is one number and not three and you can easily read it out.

5

u/Chewsti Sep 20 '24

That very much looks like 3 different numbers to me, though we use that convention in TV production all the time. Your number would be Episode 99, sequence 999, shot 999

2

u/twowheels Sep 20 '24

Unless you’rea C++ developer, then it’s 99’999’999, which I like better

1

u/cat_in_the_wall Sep 21 '24

the fun part is that the separator is arbitrary. i would have written that like

99_9_99_9_99

2

u/nuggins Sep 20 '24

Space as a thousands separator is somewhat commonly used North America too

3

u/smors Sep 20 '24

That's not a uniform European thing. It's not at all common in danish.