I did a little shell script to do it. the key was the shell variable IFS:
Normally IFS=" "
to make it work right I set it as follows:
Yes, thats a newline between the quotes
John Kopanas wrote:
> 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 :-).
One day at a time, one second if that's what it takes