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

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.

Under construction. Email me your wish list for improvements.