Brian Dunning's FileMaker Custom Functions

Tokenize ( Text ; Separator )

Returns value list of all words from Text

  Average rating: 3.9 (39 votes) Log in to vote

Ilya Shuvalov   Ilya Shuvalov
SUI Solutions
http://filemaker.suisolutions.com

Share on Facebook Share on Twitter

  Sample input:
Tokenize ( “john_smith*marysmith*family’s friend” , ”*”)
  Sample output:
john_smith
marysmith
family’s friend

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

Splits the Text on single words/phrases using the Separator.

If the empty Separator is used ("") then space (" "), dot ("."), and colon (",") are used as a word separator simultaneously

The words are returned as a value list with carriage returns

 

Comments

markv   markv, england
Jan 20, 2014
$Result variable doesn't clear itself after use of function
means any subsequent use of function adds to exiting $Result variable (builds longer and longer list ;-)
 

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.