[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Need name extraction function?

Posted on 2007-11-16
6
Medium Priority
?
258 Views
Last Modified: 2013-11-07
I need some functions that will take a person's full name as a string, and attempt to extract the various piecces of it, i.e.:

GetFirstName(), GetNamePrefix(), GetMiddleName(), GetNameSuffix()

What I would pass in would be something like:
John Doe
Dr. Alvin Chipmunk Ph.D.
Miss Mary Kate O'Reily
Mr. Alberto Juan De Laurentis

I was hoping that there might be some functions out there already to handle this so I wouldn't have to re-invent the wheel? I'll take code in either C# or VB.NET, or whatever really, as long as it can be converted to .NET of some sort.
0
Comment
Question by:toddhd
  • 3
  • 2
6 Comments
 
LVL 55

Expert Comment

by:Jaime Olivares
ID: 20300189
Is is not as easy. Consider this case:
Juan Marcelo Menotti
How you will know if Marcelo is the Middle Name or it is the second first name?
A dictionary will be useless.

You can try to attack the problem by a different side. Store the name components separately:


class PersonName
{
    string Prefix;
    string FirstName;
    string MidName;
    string LastName;
    string Suffix;
 
    public string GetFirstName() { return FirstName; }
    public string GetMiddleName() { return MidName; }
    public string GetLastName() { return LastName; } 
    // etcetera
 
    public override string ToString()
   {
         StringBuilder sb = new StringBuilder();
         if (!string.IsNullOrEmpty(Prefix))
               sb.Append(Prefix+" ");
         if (!string.IsNullOrEmpty(FirstName))
               sb.Append(FirstName+" ");
         if (!string.IsNullOrEmpty(MidName))
               sb.Append(MidName+" ");
         // etcetera
    }
}

Open in new window

0
 
LVL 55

Expert Comment

by:Jaime Olivares
ID: 20300195
sorry, ToString method should end with:

    return sb.ToString();
}
0
 
LVL 8

Author Comment

by:toddhd
ID: 20300480
jaime,
I agree with you approach completely, but I just dont have that luxury :)
I have a client (a bank no less) that has some very old data in a database where the names have been entered as one long string, and well - you guessed it, they want to get the data back out.
I am working on my own function, and made up a list of prefixes I know of to check against. Postfixes are tougher as they are practically limitless, and some have periods (Ph.D., Sr. D.D.S) and some don't (such as roman numerals). At some point, I just have to make an educated guess.

The first/last name thing is an issue with non-American names, and middle names can get out of hand sometimes as well, since there can be multiple ones.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LVL 22

Expert Comment

by:JimBrandley
ID: 20300581
I would start with a split on blanks. You can deduce some of the structure by knowing the number of elements in the name.
string fullName = "Dr. Ralph Waldo Emerson III Esq., PhD, MD";
string[] elements = fullName.Split(' ');

Jim
0
 
LVL 55

Accepted Solution

by:
Jaime Olivares earned 2000 total points
ID: 20300645
toddhd,
I have been there.
A possible approach is to make a semi-automated migration, one-by-one. Create a migration application where you suggest an interpretation and let user to choose a name structure, some UI with radio buttons  like (using Jim's example):

Full Name: Dr. Ralph Waldo Emerson III Esq., PhD, MD
 
Please correct name structure, if needed:
Dr.      (x) Prefix, ( ) First, ( ) Middle, ( ) Last, ( ) Postfix 
Ralph    ( ) Prefix, (x) First, ( ) Middle, ( ) Last, ( ) Postfix 
Waldo    ( ) Prefix, ( ) First, (x) Middle, ( ) Last, ( ) Postfix
Emerson  ( ) Prefix, ( ) First, (x) Middle, ( ) Last, ( ) Postfix 
III      ( ) Prefix, ( ) First, ( ) Middle, (x) Last, ( ) Postfix
Esq.     ( ) Prefix, ( ) First, ( ) Middle, ( ) Last, (x) Postfix
PhD      ( ) Prefix, ( ) First, ( ) Middle, ( ) Last, (x) Postfix
MD       ( ) Prefix, ( ) First, ( ) Middle, ( ) Last, (x) Postfix

Open in new window

0
 
LVL 8

Author Closing Comment

by:toddhd
ID: 31409605
jaime, I'm just going to award you the points. While it's not an exact answer, it at least tells me that I'm on the right track with what I'm doing, and that no pre-written methiod exists to do this. I'll have to post my code somewhere once I'm done so other people can use it i nthe future :)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Suggested Courses
Course of the Month10 days, 20 hours left to enroll

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question