REMOVE

Owned by Charles Bishop (Deactivated)
Jan 30, 2018

Syntax

REMOVE(<list>;<any>)

Description

Removes a value from a list.

When removing a string value from a list that the value must be surrounded by quotation marks "<string example>"

Examples

In this example we want to remove the value of 5 from our list in column1.

REMOVE(#RawData!Column1;5)

Column1

REMOVE returns

[5, 6, 7, 8]

[6, 7, 8]

[2, 3, 4, 5][2, 3, 4]
[7, 6, 5, 4][7, 6, 4]
[243, 43, 993, 12][243, 43, 993, 12]