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 together with Transform().IsNullOrEmpty()
Related functions: IsElement, IsDate, IsDefined, IsNull
Syntax:
IsNullOrEmpty(Element)- In the Quintessence Editor (Studio) using Python language, use:
Qx.IsNullOrEmpty()
ⓘ See parameter descriptions
| Element | Any 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 |
