FileMaker Pro Custom Functions

Quotes around return character are not required. Need a return at the end of the array.

Let (
[ array = ¶ & array & ¶ ]
; valuecount ( Left (
array
; Position ( array; ¶ & value & ¶; 1; 1 )
) )
)

bbb, melbourne australia
March 13, 2009 9:59am

bbb,

Thank you. Did not know quotes were not required around return character, although that does not affect functionality. Custom function works; corrected sample data.

Michael Rhodes, Rancho Cucamonga, CA
March 18, 2009 12:47pm

An array is assumed to be a value list. A return character added to the end is not necessary unless to account for an error if the array is malformed. Passing a value as the second parameter instead of text circumvents this error handling, however.

Michael Rhodes, Rancho Cucamonga, CA
March 18, 2009 12:54pm