Skip to main content

List.RemoveNulls

Removes all "null" values from the specified list.

Syntax

List.RemoveNulls(
list as list
) as list

Remarks

Removes all occurrences of "null" values in the list. If there are no 'null' values in the list, the original list is returned.

Examples

Example #1

Remove the "null" values from the list {1, 2, 3, null, 4, 5, null, 6}.

List.RemoveNulls({1, 2, 3, null, 4, 5, null, 6})

Result:

{1, 2, 3, 4, 5, 6}

Category

List.Transformation functions