Split Surname into Middle Last Name

Starter — Fri, 15 Nov 2024 20:58:54 GMT

Greetings Experts!

The Surname field contains the majority of names but needs to be standardized to follow a consistent naming convention. Generally, the first name is properly formatted, although sometimes the first name is included in the surname field, even though it's captured separately.

Furthermore, the middle name is often missing, and the surname typically holds most of the entries. However, there are occasional inconsistencies within this field, such as titles appearing at the end or unusual characters.

Nonetheless, the primary goal is to separate the surname into middle and last names.

Below is a data sample to provide a clearer understanding. Thanks in advance @marcus_sommer @rwunderlich @or @steeefan @MarcoWedel

Load * inline [
First Name,Surname
David, David N.O Plies
Ivan,Ojo-Yaw
Jim,Jim Jame Jones
ESTATE,ESTATE OF Mke Peters-Sui
Theresa,Theresa cols / Henry cols
O.,O.J Johnson (Mrs.).
lt. LT. Col Larson
Duke,Duke L.T.Y
Reagan,Rita Rosilina Addo ];

Re: Split Surname into Middle Last Name

BrunPierre — Sat, 04 May 2024 20:12:13 GMT

The overall goal might be challenging because the entries lack a consistent pattern. Hope this helps.

... Mid(Surname, Index(Surname, ' ', 1) + 1, Index(Surname, ' ', -1) - Index(Surname, ' ', 1)-1) as [Middle Name], Trim(subfield(Surname, ' ', -1)) as [Last Name] ...

topic Split Surname into Middle Last Name in App Development

Split Surname into Middle Last Name

Re: Split Surname into Middle Last Name