Hello Sir
I have been a DBA for over 17 years, have done so many complicated data parsing for many marketing companies, it will be a simple VB script to write then when executed, your data will be parsed according to your rules that will be hard coded into the VB script, the script will run under MS Access which will parse the data into an Access table from which I will move to MySQL with ease. I would be happy to also pass the script and explain it so you can run it yourself any time in the future, will also pass on the required MySQL ODBC driver for Ms Access which will be used to move the data from Access to mySql, The whole process can be automated in single click by the way. Working as DBA for many public organisations in Australia means that the confidentiality and the ownership of your data is assured and protected.
Cheers