Re: Load Data Vertical Raw using MySQL command

[Michael John]

I was given data at one time that required a lot of massaging before I could load it. It had originated from a number of sources and rather than get it into a uniform format before concatenating it all together the person had just concatenated it and then played around with it. Basically some lines had leading white space whilst others did not, a variety of field separators and numerous date formats. Unfortunately I could not get hold of the original and had to write some Python code to sort it out. It took a few attempts and some records had to be hand crafted to get everything loaded. This was all the result of the company using a non-theatrical person (sales) to request the data from the client!