@ballardw wrote: First a comment: I doubt that your data is actually fixed width unless every single name in your data is exactly 3 characters for first name and 4 characters for last name. I was creating an example for purposes of this conversation. My actual data file is much more complicated, but if I knew how to do it for this, I could make what I need for the other one. Thanks for the info, still digesting the rest of your reply, but wanted to add that note to start with. I'll be sure to use code tags / attachments for future examples. Some questions, or possibly attach a TXT file with some more example data: Does the line with the name information ALWAYS start with the same characters . Your post implies that if the first 3 characters are AAA then the line will be name information. Is that correct? And ZZZ always ends the record for the person? The first 3 chars, are always the record type in my data. The actual content is a bit different, but it is fixed width. Just many more columns.
... View more
