Re: [MSAccessProfessionals] Split full name into first and last fields

I think its going to be needed. I am dealing with 1500 record table of Native American names. So the name can be like Grey Eagle, John or Good Shield, Grace....

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Valar Dohaeris"

On Wednesday, June 3, 2020, 06:39:57 PM CDT, Duane Hookom <duanehookom@hotmail.com> wrote:

Allen's code might be a bit of overkill but it offers much greater flexibility for future requirements.

Regards,

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Doyce Winberry <doyce.winberry@xpo.com>
Sent: Wednesday, June 3, 2020 3:54 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Split full name into first and last fields

 

Art,

Look at this link from Allen Browne. I think it will get you what you want.

Doyce

http://allenbrowne.com/func-10.html

From Art:

I have a field called TenantName and it contains the full name of the tenant in this format: Doe, Jane

I need to split the first  name and the last name into separate fields called FirstName and LastName.

Any ideas?

Thank you,

Art Lorenzini