GetFirstName ( FullName )

Returns A Contact's First Name from a Full Name

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

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

Sample input:

GetFirstName(Mr. John Smith)

Sample output:

John

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

/* CF: Returns A Contact's First Name from a Full Name
    CF:  GetFirstName
             FullName
*/

Let ( [
         name= Substitute ( FullName; "-" ; "00" ); // Needed because FM treats lots of characters as separators 
         fw= LeftWords ( name ; 1 );
         title=  Case( fw= "Mr" or fw= "Mrs" or fw= "Ms" or fw= "Miss" or fw= "Prof" or fw= "Dr"; fw; "" ); // Trap title if it exists
         start= Case( WordCount(title) ≤ 0; 1; 2); // Skip title if necessary 
         start= Case( Length( MiddleWords ( name ; start ; 1 )) ≤ 1; start+1; start) // Move over 1 if initial: returns 'Thomas' if name is 'J. Thomas Smith'
         ];

Substitute( MiddleWords ( name ; start ; 1 ); "00"; "-") // Replace with dash

)

Returns an individual's First Name. Ignores titles, and will return an individual's 2nd name if the first is an initial: 'Prof. J. Harvey Smith' returns 'Harvey'.

Comments

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

GetFirstName ( FullName )

Comments

Support this website.

Support this website.