Thursday, October 22, 2009
RBC sucks at data
So I have to write some code that will bring a data file into the system. The data file is provided by RBC. Oh update no its not never mind this rant is about some company called "RBC Dexia" that may or may not have anything the fuck to do with RBC.
It is a piece of shit. It is the best thing they can give us, but it is a piece of shit. The file starts off with a bunch of header crap that is irrelevant to data processing. Then we get some blank lines, then the column headings start. Except that they are on multiple lines. And they have retarded spaces added onto their left and right for no reason. Then the data itself begins. There are numeric data fields and they all have commas shoved in the fucking numbers as a thousands separator, because you know, computers give a fuck about thousands separators. And the date format is non iso. And many of the field values have inexplicable extra space on the end. No, clearly this fucking output from RBC Dexia that I have to deal with was clearly NOT meant for machine processing, but probably meant to get printed out and shoved in front of some pointy headed fuckwit manager. And yet this is what they give us to deal with for integrating our system with their data. Shame on you RBC Dexia for sucking so much.
It is a piece of shit. It is the best thing they can give us, but it is a piece of shit. The file starts off with a bunch of header crap that is irrelevant to data processing. Then we get some blank lines, then the column headings start. Except that they are on multiple lines. And they have retarded spaces added onto their left and right for no reason. Then the data itself begins. There are numeric data fields and they all have commas shoved in the fucking numbers as a thousands separator, because you know, computers give a fuck about thousands separators. And the date format is non iso. And many of the field values have inexplicable extra space on the end. No, clearly this fucking output from RBC Dexia that I have to deal with was clearly NOT meant for machine processing, but probably meant to get printed out and shoved in front of some pointy headed fuckwit manager. And yet this is what they give us to deal with for integrating our system with their data. Shame on you RBC Dexia for sucking so much.
