Splice

Splice(array, index, howmany[, item])

Description

The splice() method adds/removes items to/from an array, and returns the removed item(s). This function changes the original array.

array: The name of an existing array.

index: An integer that specifies at what position to add/remove items, Use negative values to specify the position from the end of the array.

howmany: The number of items to be removed. If set to 0, no items will be removed.

item: Optional. The new item(s) to be added to the array at index.

Example (Basic)

At position 2, remove 2 items:

fruits = ["Banana", "Orange", "Apple", "Mango"]
Splice(fruits,2,2)

The result of fruits will be:

Banana,Orange

Example (JavaScript)

At position 2, remove 2 items:

var fruits = ["Banana", "Orange", "Apple", "Mango"];
fruits.splice(2,2);

The result of fruits will be:

Banana,Orange

Output

'Other' Upper Bound:2
'Children' Upper Bound:    3
'Parents' Upper Bounds:    3      1

Related Items

Array, Dim, LBound, ReDim