| Thanks for your post but you seem to reading too much into this or not enough.
The problem is definitly solvable.
The problem is that the original text has no specific delmited format, it seems to just be fixed with columns with all the data fields seperated by rows instead of columns.
As for the computer not knowing the difference between names and company names, it will know the difference when I'm through with it. All that takes is an added check to see if a comma is present in the original field and parse it accordingly.
The file has not been exports and looks to have been typed out by hand this way.
Thanks. |