ContainsValue ( listToSearch ; startIndex ; value )

Indicates if a list contains the specified value.

Average rating: 4.1 (29 votes) Log in to vote

Andres Cabezas
Domador Software
http://www.domador.net

Sample input:

ContainsValue ( "white¶blue¶red" ; 1 ; "blue" )

Sample output:

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

If ( ValueCount ( listToSearch ) < 1 ; 
    0 ; 
    If ( startIndex > ValueCount ( listToSearch ) ; 
        0 ; 
        If ( GetValue ( listToSearch ; startIndex ) = value ; 
            1 ; 
            ContainsValue ( listToSearch ; startIndex + 1 ; value ) 
        ) 
    ) 
)

// Created by Andres Cabezas
// http://www.domador.net
// andres.cabezas@domador.net

ContainsValue ( listToSearch ; startIndex ; value )

Inputs:
listToSearch : A carriage-return delimited list in which to look for a value.
startIndex : Position in the list at which to start looking for the value. Use 1 to start at the first element in the list.
value : Value for which to search.
Outputs:
1 if the list contains the specified value, 0 if the value is not in the list.

The startIndex parameter is required because of the recursive nature of this function.

This function requires FileMaker 8.0 or higher.

Comments

		AgnÃ¨s, France Dec 28, 2013
Hello, May be just Not IsEmpty ( Filtervalues ( ListToSearch ; Values )) or PatternCount ( Â¶ & ListToSearch & Â¶ ; Â¶ & Values & Â¶ ) > 0 give the same result. And to target valuesâ€‹â€‹, could be MiddleValues ( ListToSearch ; 5 ; ValueCount ( ListToSearch ) ) instead of ListToSearch

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

ContainsValue ( listToSearch ; startIndex ; value )

Comments

Support this website.

Support this website.