CorrespondingValue ( indexValues ; searchValue ; listOfValues )

Finds the first occurrence of searchValue in indexValues and returns the corresponding value in listOfValues.

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

Michael Horak - Show more from this author
*COMMENT Visual Realisation

Sample input:

CorrespondingValue (
"T¶N¶D" ;
"n" ;
"Text¶Number¶Date"
)

CorrespondingValue (
List ( Results::Score ) ;
Max ( Results::Score ) ;
List ( Results::Name )
)

Sample output:

"Number"

returns the name of the (first) highest-scoring result

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

/*
CorrespondingValue function

Author
*COMMENT Visual Realisation

Format
CorrespondingValue ( indexValues ; searchValue ; listOfValues )

Parameters
indexValues - a list of carriage return-delimited values
searchValue - any text expression or text field
listOfValues - a list of carriage return-delimited values

Data type returned
text

Description
Finds the first occurrence of searchValue in indexValues and returns the corresponding value (i.e. the value with the same ordinal number) in listOfValues.
The search is not case-sensitive.

August 24, 2008
*/


Let ( 
i = ValueCount ( Left ( indexValues ; Position ( ¶ & indexValues & ¶ ; ¶ & searchValue & ¶ ; 1 ; 1 ) ) )
;
GetValue ( listOfValues ; i )
)

Finds the first occurrence of searchValue in indexValues and returns the corresponding value (i.e. the value with the same ordinal number) in listOfValues.

The search is not case-sensitive.

This function is NOT recursive.

Comments

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

CorrespondingValue ( indexValues ; searchValue ; listOfValues )

Comments

Support this website.

Support this website.