User Tools

Site Tools


playground:playground

This is an old revision of the document!


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 an empty value in an If statement.


See also

playground/playground.1631505839.txt.gz · Last modified: 2021/09/13 00:03 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki