ValueExists ( )
Function stats
Average user rating
Support
FileMaker 7.0 +
Date posted
11 June 2009
Last updated
11 June 2009
Version
2.0 + View history
Recursive function
Yes
Function overview
Prototype
ValueExists (
value; valuelist )
Parameters
value The needle
valuelist The haystack
Description
Tags: in_array, in array, in value list, value list
This is the FM equivalent to PHP's in_array() function.
It is a recursive function. It will take a value list (meaning a linebreak delimited value list) and search for an exact match using the input value.
It will return 1 if an exact match is found and 0 if no exact match found.
Examples
Sample input
ValueExists("apple","apple¶pear¶peach¶plum¶cherry")
Sample output
1
Function code
Let(
[
count = ValueCount(valuelist);
curVal = LeftValues(valuelist ; 1)
];
If(
count < 2;
If(Exact ( valuelist ; value ); 1; 0);
If(Exact ( curVal; value & "¶" ) ; 1 ; ValueExists(value; RightValues ( valuelist ; count - 1 )))
)
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/230
Prototype: ValueExists( value; valuelist )
Function Author: Delta Tango (http://www.fmfunctions.com/mid/164)
Last updated: 11 June 2009
Version: 2.0
*/
// ===================================
[
count = ValueCount(valuelist);
curVal = LeftValues(valuelist ; 1)
];
If(
count < 2;
If(Exact ( valuelist ; value ); 1; 0);
If(Exact ( curVal; value & "¶" ) ; 1 ; ValueExists(value; RightValues ( valuelist ; count - 1 )))
)
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/230
Prototype: ValueExists( value; valuelist )
Function Author: Delta Tango (http://www.fmfunctions.com/mid/164)
Last updated: 11 June 2009
Version: 2.0
*/
// ===================================
Login or register to comment
Create a new account with fmcustomfunctions.com or login to post a comment.
Comments
11 June 2009
getasBoolean( valueCount( filterValues( valuelist; value)))
However, if you really need EXACT then some mods would be required.
06 September 2009