Brian Dunning's FileMaker Custom Functions

cfMatch ( value_to_test ; match_Value ; match_operator )

Test input to see whether it equals, contains, less than etc for match_value, returns boolean result

  Average rating: 4.2 (37 votes) Log in to vote

Bruce Robertson   Bruce Robertson

Share on Facebook Share on Twitter

  Sample input:
cfMatch( contacts::firstname; "B"; "bw")

cfMatch( order::total, 1000; ">")
  Sample output:
1 for first name "Bruce"

0 for order total 876

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

cfMatch ( value_to_test; match_Value; match_operator )

searches value_to_test for matchValue using operator

returns 1 if math
returns 0 if no match

operators are:

>> contains
!>> does not contain
= equals
eq equals
== exact equal

!= not equal
≠ not equal
<> not equal

> greater than
>= greater than or equal
< less than
<= less than or equal
bw begins with
!bw does not begin with
ew ends with
!ew does not end with

Bruce Robertson - Concise Design
Last updated 3/7/2010

 

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.