This looks like an import problem!

Is the sample data you provided in a database table? If so, how did it get there?

It looks like the output into a fixed width text file. First 5 characters are ID, next 40 characters are address, etc. etc.

Export it to a text file, and re-do an import. You will have to sift through the file to determine the number of characters in each field, but that will get you columns of what you need.

It may make life easier!