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.1 (37 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
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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: