Functions Language

IsNullOrEmpty

The IsNullOrEmpty() function checks whether an element has no value assigned (i.e., it is null) or is an empty value.

Unlike IsNull(), this function returns a single TRUE or FALSE value.
To evaluate each element in an array, use IsNullOrEmpty() together with Transform().

Related functions: IsElement, IsDateIsDefined, IsNull


Syntax:

IsNullOrEmpty(Element)
  • In the Quintessence Editor (Studio) using Python language, use: Qx.IsNullOrEmpty()
 See parameter descriptions

ElementAny input value.

Examples:

The examples provided below are based on fictitious data for illustrative purposes only.

> Example 1: Check if each value in an array is null


This example uses Transform to evaluate each row individually.

Range:

12/23/2014
-1
ABCD
FALSE
(Blank cell)
46001

Formula:

return := Transform(Range, "IsNullOrEmpty(C1)");

Result:

FALSE
FALSE
FALSE
FALSE
TRUE
FALSE