Brian Dunning's FileMaker Custom Functions

FilterValuesByTest ( text ; varName ; test ; include_1 )

Returns a text filtered by a test

  Average rating: 3.7 (57 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:
FilterValuesByTest ( "how incredible¶is that"; "value"; "left ( value; 1) = \"i\""; 0 )
  Sample output:
"how incredible¶" (values that do not begin with "i")

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

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

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

Adrian   Adrian, monterrey/mexico
Feb 5, 2016
Hi, i'm trying to set a filter between the same field named "date"
i want to display a list if products who were purchased between a rage

i have one field named "dateofpurchase"

for example: I want to know who products were purchased between 01/01/2015 .and. 16/02/2015

thanks for your help
 

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.