this post was submitted on 28 Feb 2024
993 points (97.2% liked)

Memes

8313 readers
1677 users here now

Post memes here.

A meme is an idea, behavior, or style that spreads by means of imitation from person to person within a culture and often carries symbolic meaning representing a particular phenomenon or theme.

An Internet meme or meme, is a cultural item that is spread via the Internet, often through social media platforms. The name is by the concept of memes proposed by Richard Dawkins in 1972. Internet memes can take various forms, such as images, videos, GIFs, and various other viral sensations.


Laittakaa meemejä tänne.

founded 2 years ago
MODERATORS
 

(skeletor is leading by example by adding that unnecessary apostrophe...)

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 15 points 8 months ago (3 children)

CSVs are supposed be comma-separated files. Microsoft deviated from the specification and decided some languages would use semicolons for CSVs.

Source: StackOverflow

[–] [email protected] 13 points 8 months ago

cemicolon separated values

[–] [email protected] 6 points 8 months ago* (last edited 8 months ago)

Microsoft deviated from the specification

There is no specification for CSV, which is why it's such a mess and different parsers and renderers have wildly different features. The closest thing to a spec is RFC4180 but that RFC simply describes the most common features across several CSV implementations, and is not actually a spec.

I agree that it should be comma separated though. My understanding is that it caused issues in countries that use a comma as a decimal point.

Also, Excel sometimes uses tabs rather than commas or semicolons.

[–] [email protected] 5 points 8 months ago

Using comma would probably caused more problems as it is a decimal separator for those languages. My excel also uses semicolon in formulas instead of comma when separating parameters. Some VBA scripts break when using different language settings and some forumilas don't translate automatically to different locale so they just give an error. Overall using excel in different locale setups is annoying.

Best separator I have used is | as i have never seen it in the data as an input. Comma and semicolon both have caused issues in the past for me as they might pop up at wrong places.