Importing Text File Into mySQL

[John Kopanas]

I have a text file with over 500K rows of data in it.  The problem is
that the data is no seperated by commas but instead  occupy a certain
amount of characters.  So for instance:

ID 1 -11
NAME 12-50
COMPANY_NAME 51-100
...

How would you parse import this data into mysql?

Thanks for your help :-).

-- 
John Kopanas
john@stripped

http://www.kopanas.com
http://www.cusec.net
http://www.soen.info