[AccessD] Splitting up names

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Thu May 11 13:36:32 CDT 2006


Look for the first space (intI = instr(1,strName," ")), then take the 
left and right parts based on the value of intI?

Rocky


John Clark wrote:
> If got a user running a db in Access. She has a list of names and they
> were all input into a single "name" field, rather than "last name" &
> "first name." She would now like to split these names up, but there are
> some double first names, as well as "jr" and "sr" suffixes. 
>
> Is there a way to do this?
>
> Basically names might be like this:
>
> JOHN SMITH JR
> MARY ELLEN SMITH
> BARBARA SMITH
>
> And I'd need to get them like this into a first name field like:
>
> JOHN
> MARY ELLEN
> BARBARA
>
> and a last name field like:
>
> SMITH JR
> SMITH
> SMITH
>
> John W. Clark
> Computer Programmer
> Niagara County
> Central Data Processing
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list