`ListAppend` formula for Nested Lists

Suggestion Box
3

@cnr there’s a Splice() formula specifically for list modification, i.e. inserting or deleting items:

List(
  List("A", "B"),
  List("C", "D")
).Splice(3, 0, List(List("E", "F")))

means at position 3 delete zero items and insert a List("E", "F") and return [A, B], [C, D], [E, F]:

image

Please note the List(List(...)) — if you just submitted a non-nested list to the Splice formula it would insert list items one by one and would get [A, B], [C, D], E, F. The Splice function unwraps one list but doesn’t unwrap the second.

5 Likes