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 - Show more from this author
ISO FileMaker Magazine
http://www.filemakermagazine.com

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)

If( stop < start or IsEmpty( list ) or IsEmpty ( start ) or IsEmpty( stop ); "BAD INPUT";

GetValue( list ; start ) & If( start < stop; ¶ & GetValues( list; start + 1; stop ) )

)

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, New York Sep 7, 2013
Cannot use "list" in a function

		Paul, Peak 14 LLC Jun 2, 2015
Danny - Just change the "list" parameter to "theList" or another name.

		Martin Pineault, f.i.SCIENCES Développement inc. Nov 14, 2020
Removed the text "BAD INPUT" for empty string and add this condition "... or IsEmpty( GetValue( list ; start ) );" to the if() to make sure list smaller than stop-start are not filled up with blank values.

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

GetValues ( list ; start ; stop )

Comments

Support this website.

Support this website.