Page 1 of 1

split full name into first and last name

Posted: Fri Dec 06, 2013 6:35 am
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 ??

Re: split full name into first and last name

Posted: Thu Dec 12, 2013 12:19 pm
by DataMystic Support
There is a filter file with TextPipe called fix name capitalization.fll - this will be a good starting point.