Brian Dunning's FileMaker Custom Functions

RootKeywords ( text ; separator )

variation on keyword function that removes plural and adjective word endings

  Average rating: 4.4 (31 votes) Log in to vote

avi   avi

Share on Facebook Share on Twitter

  Sample input:
RootKeywords( "huge knives, "|" )
  Sample output:
huge knives|huge knife

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

Matching multikey words so that english language plurals match singular words is tricky. This function adds more word endings to the original keyword function including irregular plurals and descriptive endings like "ish" (sorry, no adverbs this time around). The function only parses the last word in the string if there are more than one word.



Log in to post comments.


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

Under construction. Email me your wish list for improvements.