Skip to end of banner Go to start of banner

REMOVEALL

Skip to end of metadata

Created by Juliane Wetzel on Apr 29, 2020

Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Syntax

REMOVEALL(<list>;<list>;...)

Description

Removes all elements from one list that exist in a specified list or lists.

Examples

REMOVEALL(#Column1;#Column2)

Column1	Column2	REMOVEALL returns
[1, 2, 3, 4]	[3, 4, 5, 6]	[1, 2]
[3, 4, 5, 6]	[1, 2, 3, 4]	[5, 6]
[7, 2]	[7, 6, 5, 4]	[2]
[243, 43, 12]	[243, 43, 993, 12]	[]

No labels