Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API

From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
C0D4647763yOr export to excel,
Or macro in excel,
Or excel.... fuck me dead so much excel, seriously I do more excel then I do anything else 😢
I do enjoy csv to sql imports though, big data just got easy, and then export back to excel and make everyone think your the excel master 😁 -
@C0D4 One time, about 14 years ago, I was esked to make a server monitoring excel shit which sends emails ;p ;p ;p
I was young. I did it. But no... that shouldn't exists -
Storytime: In early 2021 I interviewed with 3 or 4 different companies, all extremely well paying and very successful, but yes, their apps all boiled down to "import or export your data into our tables or *GASP*, even import your CALENDAR data, and we'll add a layer of fun easy drag and drop logic!" yawn.
-
@tosensei CSV is not much better, fucking customers never encode them properly...
- UTF-8 encoded ISO-8859-1 chars, sometimes the opposite
- newlines (0x0a) within strings making most CSV parsers to read it as a new row
- missing column spearators
- too many column setarators
- mixed column separators
In the case of the newline problem, I had to write my own CSV parser with a custom state machine. I'm not a huge fan of Excel either, but at least shit like this doesn't happen there.
Related Rants
-
hcaz24A new way of making bad commits: alias fuckit='git commit -m "$(curl -s whatthecommit.com/index.txt)"' Its li...
-
Cyanide11I officially hate React, now. Hooks are bullshit. useEffect can die in hell.
-
Rick-C1374Having one of those moments when I question why I am a dev and why the world is such a shithole. Fucking ear...
All B2B solutions boil down to "How I import your Excel"
rant
fuckit