cfMatch ( value_to_test; match_Value; match_operator )
Rate this function: Average rating: 5.0 (1 vote)
Discuss this Custom Function
Bruce Robertson, Concise Design
http://concise-design.com
Test input to see whether it equals, contains, less than etc for match_value, returns boolean result
Sample Input:
cfMatch( contacts::firstname; "B"; "bw")
cfMatch( order::total, 1000; ">") |
|
Sample Output:
1 for first name "Bruce"
0 for order total 876 |
|
Description:
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
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:
|
Newest Custom Functions:
| 1. |
MaxLength ( field, foundCnt ) |
| |
(Thu, Jul 29, 4:37pm) |
| 2. |
DayCounter ( Date_Start ; Date_End; Days_of_Week ) |
| |
(Wed, Jul 28, 1:20pm) |
| 3. |
Is_FM_Go_iPad |
| |
(Fri, Jul 23, 7:55am) |
| 4. |
Is_FM_Go |
| |
(Fri, Jul 23, 7:54am) |
| 5. |
IsFilled ( field ) |
| |
(Wed, Jul 21, 7:19am) |
| 6. |
DateQuarterAsRange ( theDate ) |
| |
(Thu, Jul 15, 5:37pm) |
| 7. |
DateQuarterEnd ( theDate ) |
| |
(Thu, Jul 15, 5:35pm) |
| 8. |
DateQuarterBegin ( theDate ) |
| |
(Thu, Jul 15, 5:30pm) |
 |
|
