_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
APHIS USDA
http://www.aphis.usda.gov/

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)

//_fn_Insert2SortedNumList(SList; Value; Order)
/*
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
*/

Let ( [
     L=ValueCount(SList);
     V1= GetAsNumber(GetValue(SList;1))
     ] ; 
     Case (
          IsEmpty(Value); 
               SList;        //no Value return the SList
          L=0;
               value;
          Order="D";
               Case(value   ≥  V1; 
                         value & ¶ & SList; 
                         V1 & ¶ & _fn_Insert2SortedNumList(RightValues(SList; L-1); Value; Order)
               );
          Order="A";
                Case(value  ≤  V1; 
                         value & ¶ & SList; 
                         V1 & ¶ & _fn_Insert2SortedNumList(RightValues(SList; L-1); Value; Order)
                );
          SList
     )
)

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

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

_fn_Insert2SortedNumList ( SList ; Value ; Order )

Comments

Support this website.

Support this website.