FileMaker Pro Custom Functions

/* Name: array.cellValueByColNum History: Created by Tim Anderson, Tim Anderson Group www.timanderson.co.uk Creation Date: 5 January 2009 Modified: 6 January 2009 - now treats the row names as column 0 and name change to take account of enhanced version array.cellValueByColTitle Purpose: A function to return the column value from an array by specifying the row name. Row names must be unique or only the first occurrance will be returned. Parameters: array rowName column delimiter Example: array.cellValueByColNum ( array ; "jelly" ; 2 ; "§" ) gives "very wobbly" (no quotes) where array is row1§40§200 row2§200§40 jelly§very wobbly§raspberry Requires Other Custom Functions: None Other Notes: Have included the option to specify the delimiter for most flexible use Options: None */ Let([_rname="¶" & rowName & "§"; _notHere=PatternCount(array;_rname)=0; _string=Right("¶" & array;Length(array)-Position("¶" & array;_rname;1;1)); _row=GetValue(_string;1)]; Choose(_notHere;GetValue(Substitute(_row;delimiter;"¶");column+1);"") )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.