FILTER function

The FILTER function allows you to perform an action (function) over each element of an array deciding whether it should stay in the array or not. Resulting in a new filtered array.

Syntax

The syntax for FILTER is as follows

FS
FILTER(array, f)
  • array an array (collection/list) of values
  • f the function you want to apply to each value (can be built-in or a custom function)

The result is another array

Examples

FS
// only keep values that are numbers
FILTER(ARRAY(1, 2, -5, 'string', ARRAY(), true), ISNUMBER)  // -> [1, 2, -5]

// only keep value that are positive (greater or equal to 0)
FILTER(ARRAY(-5, -3, 3, 5, 100, -100, 0), function(x: x >= 0))  // -> [3, 5, 100, 0]

Related articles

Learn more about filter in one of the following articles