split full name into first and last name

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

split full name into first and last name

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

Re: split full name into first and last name

Postby 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, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest