Brian Dunning's FileMaker Custom Functions

split ( string ; delimeter ; occurrence )

Splits a string based on a character delimiter and returns the value at the nth position

  Average rating: 4.2 (41 votes) Log in to vote

Tami Williams   Tami Williams
Creative Computing
http://www.asktami.com

Share on Facebook Share on Twitter

  Sample input:
split ( "tom jane mary"; " "; 2 )
  Sample output:
jane

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

// split ( string; delimiter; occurrence )
// Splits a string based on a character delimiter and returns the value at the nth position


Sample Input:
split ( "tom jane mary"; " "; 2 )

Sample Output:
jane

Description:
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

Author:
Tami Williams
www.asktami.com
info@asktami.com

 

Comments

BonnieS   BonnieS, Washington DC
Jun 8, 2018
Tami
Just wanted to say THANK YOU! This little function just saved me a ton of time and energy!
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.