Re: un-stringing??

[John Milardovic <milardj@SX.COM>]

Assuming a maximum of three names (given, surname, and middle name) and
assuming that middle name will always be the second name in the string then
this will work.

        unstring $name by ' ' into $name1 $name2 $name3
        if isblank($name3)
                let $first_name = $name1
                let $surname   = $name2
        else
                let $first_name= $name1
                let $surname   = $name3
                let $initial        = subbstr($name2,1,1)
        end-if

I know.  Thats alot of ASSUMING.
HTH anyway.

John Milardovic

> -----Original Message-----
> From: Buchanan, Timothy [SMTP:buchanan@BIPERF.COM]
> Sent: Wednesday, June 23, 1999 4:08 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      un-stringing??
>
> Any easy way to take data from a table such as:
>
> Bob Smith
> Jane A. Doe
> Billy Joe Whitaver
>
>
> and parse it out into Last Name, First Name and Middle Initial??????
>
>
> Thanks in advance...
>
> Timm