User Tools

Site Tools


syntax:functions:empty

Empty()

Category: Special function


Description

This function creates an empty value.


Use cases

Use empty() to insert empty values into cells, or within other functions.


Arguments

This function does not require arguments.

Return value type: Empty value


Remarks

While a value can be tested for an empty value using a "value = empty()" expression, the IsEmpty function can also be used. The two approaches are equivalent.


Examples

[Content] = empty()  //Returns TRUE if [Content] contains an empty value, otherwise, FALSE.
coalesce(empty(), 'ABC', '')  //Using empty() as an argument within a function.
if( [Value] = 10, 'Ten', empty() )  //Using empty() to set a return empty value in an If statement.


See also

syntax/functions/empty.txt · Last modified: 2021/09/13 00:06 by craigt