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.

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: