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 - Show more from this author
1-more-thing https://www.1-more-thing.com |
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 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 |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.