Brian Dunning's FileMaker Custom Functions

FilterWordsByTest ( text ; varName ; test ; include_1 ; mode )

Returns a text filtered by a test

  Average rating: 3.8 (38 votes) Log in to vote

Fabrice Nordmann   Fabrice Nordmann - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
FilterWordsByTest ( "how incredible is that"; "word"; "length ( word ) < 4"; 1; ¶)
  Sample output:
how¶is" ( words shorter than 4 characters, formatted as a list)

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

Regular expressions in FileMaker !
This is a very custumisable function, read the comments to know more about it.
Virtually any type of text parsing is possible with this function and FilterValuesByTest.

UPDATE : I would now recommend the use of CustomList, by Agnès Barouh :, or FilterList :



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: