It is telling that the replies from ptum, esper and ruzam all contain the caveats "if your data ... " or "if your lines ... " or the like. I think it would be helpful here if you could post a sample of the data.
Cheers,
JohnGG
Comment on Re: Capturing columnar data from a text file