Table of Contents

Coalesce(value1, value2…)

Category: Special function

Description

This function returns the first value in the argument list that is not an empty value.

Alternate formats

This function can take from 2 to 6 values as arguments.

coalesce(value1, value2, value3, value4, value5, value6)

Arguments

ArgumentTypeDescription
valueNAnyA value tested to determine whether it represents an empty value or not.

Return value type: Any (The type of the returned, non-empty value.)

Remarks

To use the function with more than 6 arguments, nest function calls. Keep in mind that arguments are evaluated before a function is evaluated.

If all arguments are empty values, an empty value is returned.

Examples

coalesce(empty(), 'ABC', '')  //Returns 'ABC'
coalesce(empty(), '', 'ABC')  //Returns '' (Empty text value but not an empty value.)
coalesce(empty(),empty())  //Returns an empty value  (All arguments are empty values.)
coalesce(empty(), coalesce('ABC',empty()) ,'XYZ')  //Returns 'ABC'  (Nested functions)

See also