IsElement
The IsElement() function checks whether a specified value exists within an array.
Related functions: IsDate, IsDefined, IsNull, IsNullOrEmpty
Syntax:
IsElement(Element, Array)- In the Quintessence Editor (Studio) using Python language, use:
Qx.IsElement()
ⓘ See parameter descriptions
| Element | Any string or numeric value to search for. |
| Array | An array of elements. |
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Check whether 1 is present in an array (returns FALSE)
Range:
| 12/23/2014 |
| -1 |
| ABCD |
| FALSE |
| (Blank cell) |
| 46001 |
Formula:
return := IsElement(1, Range);Result:
| FALSE |
> Example 2: Check whether -1 is present in an array (returns TRUE)
Range:
| 12/23/2014 |
| -1 |
| ABCD |
| FALSE |
| (Blank cell) |
| 46001 |
Formula:
return := IsElement(-1, Range);Result:
| TRUE |