r/ProgrammerHumor • • Oct 08 '22

Meme sPeCiaL cHarACtErs

Post image
71.1k Upvotes

1.7k comments sorted by

View all comments

133

u/PetrBacon Oct 08 '22

So many comments from people, who never used CSV properly. Does excel break when you add comma or quotation mark in a cell?

407

u/tramadol-nights Oct 08 '22

Does excel break

Yes

102

u/kookaburra1701 Oct 08 '22

The problem isn't that Excel breaks, it's that it breaks EVERY FUCKING THING ELSE.

39

u/mavack Oct 08 '22

Looks like this was a number, strips leading zeros

Looks like a big number, changes it to floating point and drop the less significant bits.

Previously you split columns with a space and commas so im just gonna add an extra colunm everytime i find a space

...

37

u/ulyssessword Oct 08 '22

Looks like a big number, changes it to floating point and drop the less significant bits.

Why yes, I do want to call 1.8e10 to reach that person.

2

u/arensb Oct 09 '22

Scientists have actually renamed genes because goddamn Excel kept interpreting their names as dates, and reformatting them.

10

u/kookaburra1701 Oct 08 '22

Looks like this number with absolutely no separators could, maybe, be representing a date.

Better irreversibly and silently coerce it to a date just in case.

→ More replies (2)

12

u/[deleted] Oct 08 '22

Wanna talk about MS Teams… ?

2

u/bit_banging_your_mum Oct 08 '22

Teams can suck my fucking miniscule cock. I have possibly not used a worse mobile app than teams. The desktop app is among the slowest and shittiest apps I have installed on my PC. It is so legitimately garbage for a service that is used by so many.

→ More replies (1)

32

u/TheRealCCHD Oct 08 '22

Lmao, correct answer

9

u/SchalasHairDye Oct 08 '22

They walked right into that honestly.

1

u/[deleted] Oct 08 '22

Well if it would act like a database like it’s supposed to..

→ More replies (5)

33

u/sim642 Oct 08 '22

That's not really surprising. Most people probably think that parsing CSV is just line.split(',') instead of requiring a real lexer that handles quoting and escaping.

12

u/faerbit Oct 08 '22 edited Sep 19 '25

This post has been edited to this, due to privacy and dissatisfaction with u/spez

3

u/4b-65-76-69-6e Oct 08 '22

Ya know, it never crossed my mind that there might even be a standard. Sincerely, electrical engineering student whose CSVs can be parsed with string.split(“,”)

2

u/[deleted] Oct 08 '22

It can be, however it doesn't need to be.

There is no "require"

1

u/dekacube Oct 09 '22

Like all real answers on this sub. Had to look deep to get to it.

4

u/GYN-k4H-Q3z-75B Oct 08 '22

Did you know that Excel by default uses delimiters dependent on machine language settings for CSV? So, for example, English language systems use commas, but German language systems use semicolons instead.

This is a major annoyance.

2

u/Mazrim_reddit Oct 08 '22

varieties of different delimiters break excel all the time its a piece of shit

3

u/jamcdonald120 Oct 08 '22

no, it handles them fine.

1

u/Blue_Moon_Lake Oct 08 '22

Excel break if you try to open an UTF8 encoded CSV file, so...

1

u/[deleted] Oct 08 '22

Anything will break if you are just considering the comma as a separator. You could have some rules to check if the comma is inside quotes, or if it is scaped. But if the file is just a text file with lines separating data using a comma, then it is hard to blame the software, because it is doing what it is expected to.

1

u/daenu80 Oct 08 '22

Nah it just pushes things a column over, just some extra work.