IsDefined
The IsDefined() function determines whether an input parameter has a value assigned to it.
Related functions: IsDate, IsElement, IsNull, IsNullOrEmpty
Syntax:
IsDefined(Element)- In the Quintessence Editor (Studio) using Python language, use:
Qx.IsDefined()
ⓘ See parameter descriptions
| Element | Any input value to be tested. |
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Check if each value in an array is defined
Range:
| 12/23/2014 |
| -1 |
| ABCD |
| FALSE |
| (Blank cell) |
| 46001 |
Formula:
return := IsDefined(Range);Result:
| TRUE |
| TRUE |
| TRUE |
| TRUE |
| FALSE |
| TRUE |