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

Art, 

Are you suggesting the example you provided "Doe, Jane" is not consistent in all the records? If not, then you really need to provide a good sampling of your data values when you ask your question.

IMO: you should never store last and first names together. I always create at least FirstName and LastName and might even add middle name/initial as well as prefix and suffix depending on requirements.

Regards,

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via groups.io <dbalorenzini=yahoo.com@groups.io>
Sent: Thursday, June 4, 2020 10:22 AM
To: MSAccessProfessionals@groups.io <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