Re: un-stringing??

[John Milardovic <milardj@SX.COM>]

Hey Timm.

It doesn't matter if its an initial or the full middle name or neither, it
will still work (in its own limited fashion :-) assuming that middle name,
if it exists, comes second and last name always comes second or third.

It will definitely not work for the scenarios that Nicole mentioned (i.e..
Oscar De Le Renta etal.).  I'll be very impressed with any solution that can
handle Nicole's suggestions as well as hyphenated names.

John De Le Hoya Aston-Martin

> -----Original Message-----
> From: Buchanan, Timothy [SMTP:buchanan@BIPERF.COM]
> Sent: Wednesday, June 23, 1999 4:50 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: un-stringing??
>
> 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