GetValues ( listOfValues ; valueNumbers )

Returns values in the positions given by valueNumbers.

Average rating: 4.3 (13 votes) Log in to vote

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

Sample input:

GetValues ( "Red¶Cyan¶Green¶Magenta¶Blue" ; "5¶1¶3" )

GetValues ( "Red¶Cyan¶Green¶Magenta¶Blue" ; "5¶1¶1¶3" )

Sample output:

Blue
Red
Green

Blue
Red
Red
Green

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

/*
GetValues function

Author
*COMMENT Visual Realisation

Format
GetValues ( listOfValues ; valueNumbers )

Parameters
listOfValues - a list of carriage return-delimited values
valueNumbers - a list of carriage return-delimited numeric values

Data type returned
text

Description
Returns values in the positions given by valueNumbers. Returned values are listed in the order of their positions in the valueNumbers parameter.

September 21, 2016
*/

Let ( 
n = ValueCount ( valueNumbers )
;
MiddleValues ( listOfValues ; GetValue ( valueNumbers ; 1 ) ; 1 ) 
&
If ( n > 1 ; GetValues ( listOfValues ; RightValues ( valueNumbers ; n - 1 ) ) )
)

Returns values in the positions given by valueNumbers. Returned values are listed in the order of their positions in the valueNumbers parameter.

As with all value functions, the result of GetValues() has a trailing carriage return.

Comments

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

GetValues ( listOfValues ; valueNumbers )

Comments

Support this website.

Support this website.