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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: