Solved: name string

peppapig · Posted 09-09-2013 11:24 AM

SALATA,EDYTA

CORNELL,NANCY A.

ROUNDTREE,WILLA M.

how to remove the middle name listed in the end of the name like A. M. above?

Thanks!

Tom · Posted 09-09-2013 12:07 PM

For these simple examples you can use SCAN with blank as the delimiter since there are no blanks between the last and first name.

scan(name,1,' ')

But real names are more complicated than this. What about people with spaces in their first name or last name? Or those that use initials?

Tom · Posted 09-09-2013 12:07 PM

For these simple examples you can use SCAN with blank as the delimiter since there are no blanks between the last and first name.

scan(name,1,' ')

But real names are more complicated than this. What about people with spaces in their first name or last name? Or those that use initials?

peppapig · Posted 09-10-2013 10:09 AM

Thank you very much for your great help!

name string