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

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
*/

Case( 

match_operator  = ">" and  value_to_test  >   match_Value  ; 1 ;
match_operator  = ">=" and  value_to_test >=   match_Value  ; 1 ;
match_operator  = "<" and  value_to_test <   match_Value ; 1 ;
match_operator  = "<=" and  value_to_test <=   match_Value ; 1 ;

match_operator = ">>" and  PatternCount( value_to_test ; match_Value) ; 1 ;
match_operator = "!>>" and  PatternCount( value_to_test; match_Value) = 0 ; 1 ;

match_operator = "=" and value_to_test  = match_Value ; 1;
match_operator = "eq" and value_to_test  = match_Value ; 1;
match_operator = "==" and Exact( value_to_test  ; match_Value ) ; 1 ;

Exact( match_operator; "!=" )  and ( value_to_test   <> match_Value ) ; 1 ;
(match_operator  = "<>") and ( value_to_test   <> match_Value ) ; 1 ;
Exact( match_operator ; "≠" ) and ( value_to_test   <> match_Value ) ; 1 ;

match_operator  = "bw" and  Left( value_to_test   ; Length( match_Value) ) = match_Value ; 1 ;
match_operator  = "!bw" and Left( value_to_test   ; Length( match_Value) ) <> match_Value ; 1 ;

match_operator  = "ew" and  Right( value_to_test   ; Length( match_Value) ) = match_Value ; 1  ;
match_operator  = "!ew" and Right( value_to_test   ; Length( match_Value) ) <> match_Value ; 1 ;

0
)

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

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

cfMatch ( value_to_test ; match_Value ; match_operator )

Comments

Support this website.

Support this website.