| The problem is that all fields of the records seem to be optional.
You'll need to provide a better definition then "fixed with columns".
The columns-part I could find out myself.
Example:
For the first record, both ADDRESS 1 and ADDRESS 2 are provided. But for the second record ADDRESS 2 is missing. Yet everything is space delimited. So how would the computer know that the next <string> isn't a "ADDRESS 2" ?
For the system to know, there must be a clear definition. Obviously that has to do with delimiters. Note that the system doesn't have an intuition like we do.
__________________ |