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 ??
split full name into first and last name
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators
- 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
There is a filter file with TextPipe called fix name capitalization.fll - this will be a good starting point.