FileMaker Pro Custom Functions

/* 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 )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.