Work rage, totally self-inflicted. Got a fucking messy data file from a customer of our competitor's who is switching to us.
And I thought, easy-peasy, I'll just work with the spreadsheet, using our little data importing tool....
NO. BAD TECH SUPPORT. TURN NOT AWAY FROM THY DATABASE.
It should have been self-evident, but copy/pasting from an excel spreadsheet into MANY spreadsheets, over several hours, tends to introduce user error. A lot of user error.
Not only that, but spreadsheets come with white space that makes, well, everything fuck up. Nevermind that shit dongle that is Excel, which I haven't really used since highschool, and that was a long, long time ago.
So in about 10 hours I managed to hack apart a data file, clean it up, get it inserted, only to discover....inventory counts are off! And part numbers are referencing the wrong parts!
So I just spent ~5 hours after the close of business, while everyone else is drinking beer and enjoying the end of their work week at a company social event, doing what I should have fucking done in the first place, which was insert the raw data into the database and work query magic on it. LTRIM(RTRIM(blah))? DONT MIND IF I DO.
Christ, I don't know what I was thinking or where my head was at. I'm pretty sure my coworkers think I'm a psychopath at this point, for the amount of swearing and getting up angrily to go fume in private at how fucking retarded this all was.
I think the truth is I've always felt under-qualified for many parts of this job, and my insecurities start turning to rage and frustration when I hit the limit of my intellect. In the end though, I made a stupid choice from the outset and I'm just angry at myself for not knowing, or doing, better. No one at work even cares. They probably care more about me raging out than anything else. *sigh*