That would be impossible for me to answer here; I would have to be in your database to do it. However, here are a couple of guidelines to make things easier going forward:

1) You're probably going to have to scrub the data more or less manually, to get it into an easily parsed form.
2) You're going to have to change your input procedures so that it does the data scrubbing for you going forward.

THEN you can write your parsing routine.

Hope this helps!