Here is a snapshot of the data I am importing:
james smith" <firstname.lastname@example.org> "a allen" <email@example.com>, "aaron jones" <firstname.lastname@example.org>,adam smith ii <email@example.com>
Program I wrote:
length FName $10 LName $20 email $40 ;
infile 'v:\orion\mymembers.txt' dlm = '" < > ,';
input FName $ LName $ email $ ;
When I run it, the program pulls the first record only. One issue is that a few of the records show a name suffix. Another issue is that the data shows multiple names and emails on the same row. How can I address both issues. I would not mind combining the suffix with the last name.
Advertise on Talk Stats