Brian Dunning's FileMaker Custom Functions

array.cellValueByColTitle ( array ; rowName ; column ; delimiter ; useTitle )

A function to return the cell value from an array by specifying the row name and column title

  Average rating: 4.4 (36 votes) Log in to vote

Tim Anderson   Tim Anderson
Tim Anderson Group

Share on Facebook Share on Twitter

  Sample input:
array.cellValueByColTitle ( array ; "row2" ; "length" ; "§";1 )

array.cellValueByColTitle ( array ; "row3" ; 1 ; "§";0 )
where array is
row1§40§200§23§160
row2§200§40§98§121
row3§500§32§12§90
  Sample output:
40
500

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

A function to return the cell value from an array by specifying the row name and column title. Row names must be unique or only the first occurrance will be returned.

A more complex version of array.cellValueByColNum, this gives you the option to specify column Titles (headers) rather than by number. However you can also specify the column number (the row name is zero) as long as you set useTitle to 0.

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.