Brian Dunning's FileMaker Custom Functions

_fn_Insert2SortedNumList ( SList ; Value ; Order )

insert a numeric value into a sorted numeric list

  Average rating: 4.7 (32 votes) Log in to vote

Lizhe Xu   Lizhe Xu
APHIS USDA
http://www.aphis.usda.gov/

Share on Facebook Share on Twitter

  Sample input:
If Slist is
23
56
78
128
200
230

_fn_Insert2SortedNumList(SList; 181; "A")
  Sample output:
23
56
78
128
181
200
230

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

Function:
insert a numeric value into a sorted numeric list and keep the list in correct sorted order
Parameters:
SList: pre-sorted numeric list
Value: the numeric value to insert
Order: indicate the order type of the SList; "A"=ascending list; "D"=descending list
Requirement:
Slist must be a sorted list

 

Comments

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: