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 - Show more from this author

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: