ListRemoveItemAtIndexNumItems ( inputList ; index ; numItems )

Removes one or multiple items from list starting at index

Be the first to rate this function Log in to vote

Farid Mezaber - Show more from this author

Sample input:

ListRemoveItemAtIndexNumItems(List("a";"b";"c";"d";"e";"f";"g";"h";"i"), 1, 3)

Sample output:

d e f g h i (spaces are actually "¶" characters)

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

/*
 ListRemoveItemAtIndexNumItems(inputList, index, numItems)
 Parameters:
 1. inputList (FileMaker valuelist with "¶" delimiters)
 2. index (int)
 3. numItems (int), number of items to remove starting at "index"
 Example: newList = ListRemoveItemAtIndexNumItems(oldList, 1, 3) will remove the first three items
 (c) chebfarid 2026
*/

Let( 
 [
  c = ValueCount ( inputList ) ;
  x = index + numItems -1 ;
  // this loop runs from last index (idx) to first index (index)
  List_A = While(
   // modifiedList is the updated version of inputList after each loop/removal
   [ idx = x ; List_B = "" ; modifiedList = inputList ] ; 
   idx >= index ; // we loop BACKWARDS, loop ends when x < index
   [ 
    List_B = While ( 
     [ i = 1 ; List_C = "" ] ;
     i <= c ;
     [	
      List_C = If (
       i ≠ idx ;
       List ( List_C ; GetValue ( modifiedList ; i ) ) ;
       List_C
      ) ;
      i = i+1 
     ] ;
     List_C
    ) ; // end While_B
    // modfiedList is the updated version of inputList after each removal
    modifiedList = List_B ;
    idx = idx-1
     ] ;
     List_B
    ) // end While_A
   ] ;
   List_A
)

Still another custom function to remove items from a valuelist.
The function uses two While( ) loops.
Have fun !

Comments

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

ListRemoveItemAtIndexNumItems ( inputList ; index ; numItems )

Comments

Support this website.

Support this website.