split full name into first and last name

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

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

split full name into first and last name

Post by edekker »

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: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: split full name into first and last name

Post by DataMystic Support »

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