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
http://www.filemakermagazine.com

Share on Facebook Share on Twitter

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

  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!

 

Comments

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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.