Brian Dunning's FileMaker Custom Functions

GetValues ( list ; start ; stop )

Extends the standard GetValue function to extract multiple values in a return delimited list

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

Matt Petrowsky   Matt Petrowsky
ISO FileMaker Magazine

Share on Facebook Share on Twitter

  Sample input:
GetValues ( "1¶2¶3¶4¶5¶6"; 3; 5 )
  Sample output:

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

Function uses the GetValue function to extract a range of values from a return delimited list. Currently uses a start and stop value but could be modified to use a start and length value. You would need to modify the exit condition of "start < stop".

I tend to supply a length value to the stop parameter. (e.g. start + length = stop) or ( (start + length) - 1 = stop ).

Using a Let function makes things much easier!



Danny   Danny, New York
Sep 7, 2013
Cannot use "list" in a function
Paul   Paul, NY
Jun 2, 2015
Danny - Just change the "list" parameter to "theList" or another name.

Log in to post comments.


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

Under construction. Email me your wish list for improvements.