Re: un-stringing?? - names

[Sam Spritzer <SSpritzer@GW.CTG.COM>]

Timm...
Your best bet is to separate all of the parts of the name using the comma and 
space as separators.  Now...that is relatively simple.  Anything to the left of 
the comma is a LAST_NAME.  As for the FIRST_NAME and MIDDLE_INIT...I would 
wonder how many employees you would have that do have a first name and a middle 
init.  More often, you'll find that to be manageable so that the users can make 
the corrections.
As for the users....well, that is a whole different story...
Sam

Gracen - I actually like your idea better but I also like my job too!! :)

<<< "Buchanan, Timothy" <buchanan@BIPERF.COM>  6/23  5:43p >>>
I already tried that!!! Actually, I used hex instead of ascii. :)

Timm


On Wednesday, June 23, 1999 4:19 PM, Gracen Duffield
[SMTP:gduffiel@TDHCA.STATE.TX.US] wrote:
> convert all the letters to numbers using ascii values, divide by pi, and
> tell everyone they now have to go by their "Buchanan ID".
>
>
> Gracen Duffield
> Texas Department of Housing and Community Affairs
> 475-3839
>
>
> -----Original Message-----
> From: Buchanan, Timothy [mailto:buchanan@BIPERF.COM]
> Sent: Wednesday, June 23, 1999 3:55 PM
> To: Multiple recipients of list SQR-USERS
> Subject: Re: un-stringing?? - names
>
>
> Thanks Nicole, now I am REALLY confused!! :)
>
> Timm Yun Fat De La Rue
>
>
>
> On Wednesday, June 23, 1999 3:42 PM, Nicole Byrd [SMTP:nbbyrd@EMORY.EDU]
> wrote:
> > And what about Oscar De La Renta or Chow Yun Fat or Mary Lou La Rue?  Is
> > "Mary" the first name, or is it "Mary Lou"?  How do you decide that "La
> Rue"
> > is the last name, and not just "Rue"?  Is "Chow Yun" the first name, or
is
> > "Yun Fat" the last name, or is "Yun" the middle name?
> >
> > Nicole Byrd
> >
> > > -----Original Message-----
> > > From: Discussion of SQR, SQRIBE Technologies's database reporting
> > > language [mailto:SQR-USERS@LIST.IEX.NET]On Behalf Of Buchanan, Timothy
> > > 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
> > >