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
1-more-thing
https://www.1-more-thing.com

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 : http://www.briandunning.com/cf/747, or FilterList : http://www.briandunning.com/cf/771

 

Comments

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.

Under construction. Email me your wish list for improvements.