GetLastName ( FullName )

Returns an Individual's Last Name From A Full Name

Average rating: 4.1 (29 votes) Log in to vote

Steve Bush - Show more from this author
Intellisoft Development
http://www.intellisoftdevelopment.com

Sample input:

GetLastName(Mr. John Smith III)

Sample output:

Smith

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* CF: Returns A Contact's Last Name from a Full Name
    CF:  GetLastName
            FullName
*/

Let ( [
         name= Substitute ( FullName; "-" ; "00" ); // Needed because FM treats lots of characters as separators
         nword= WordCount( name ); 
         rw= RightWords ( name ; 1 );
         suffix =  Case( rw= "SR" or rw= "JR" or rw= "II" or rw= "III" or rw= "IV" or rw= "MD" or rw= "DR" or rw= "PhD" or rw= "Esq"; rw;"") // Trap suffix if it exists
        ];

Substitute( Case( WordCount( suffix) > 0; MiddleWords ( name ; nword -1; 1 ); MiddleWords( name; nword; 1 ) ); "00"; "-") // Replace with dash

)

Returns an individual's last name from a Full Name and ignores suffixes like 'Sr.', 'Jr.', etc.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetLastName ( FullName )

Comments

Support this website.

Support this website.