Re: un-stringing??

["Buchanan, Timothy" <buchanan@BIPERF.COM>]

I was thinking of something along these lines, but not all of the data in
the source tables has a middle name. Some just have a middle initial, most
have no initial.

thanks

Timm


On Wednesday, June 23, 1999 3:31 PM, John Milardovic [SMTP:milardj@SX.COM]
wrote:
> 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