FileMaker Pro 13 Custom Function: Split Text String

Modified on September 13, 2014.

This function will split up a string based on a character you specify and then return the value at the position/occurence specified

Uses:
– Separating data in a single field based upon a specific character
– Extracting Title, First Name, Middle Name, Last Name from a field and splitting those field contents into multiple fields

Sample Input:
split ( “tom|jane|mary”; “|”; 2 )

Sample Output:
jane