split full name into first and last name

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 2
Joined: Fri Dec 06, 2013 6:06 am

split full name into first and last name

Post by edekker » Fri Dec 06, 2013 6:35 am

With a full name consisting of 2 words, it is not very difficult to split a name in first and last name. It get difficult with three or more words, because you need to understand the words.

if there is a hyphen (Mary-Ellen, Johnson-Leboeff), the 2 connected words should be considered one.
if there is a 1 letter abbreviation (T.) the word before would be the first name, the word after this 1 letter abbrevation is the last name. (but I have seen T. Harvey Johannson)
if there is a 2 letter abbreviation (Jr. or Sr.) the word left of this abbrevation is the last name.
then there are double or triple last names (von Acker, van der Zand)

Anyone wants to help to make this into a filter that would cover 80 -90 % in the first sweep ??

User avatar
DataMystic Support
Site Admin
Posts: 2237
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Re: split full name into first and last name

Post by DataMystic Support » Thu Dec 12, 2013 12:19 pm

There is a filter file with TextPipe called fix name capitalization.fll - this will be a good starting point.

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads

Post Reply