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

Why couldn't you leave the name field as "last, first", then add an additional field such as "AKA" which would be the Native name ie.  "Grey Eagle" or "He who walks with the wind" – English version of Native name.  ?????

 

 

 

Sent from Mail for Windows 10

 

From: Art Lorenzini via groups.io
Sent: Thursday, June 4, 2020 8:22 AM
To: MSAccessProfessionals@groups.io
Subject: 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