containsNonFinite
containsNonFinite
returns a boolean value indicating whether or not the specified value is non-normal, where normal is defined as not null, not infinite, and not NaN.
Syntax
containsNonFinite(values...)
Parameters
Parameter | Type | Description |
---|---|---|
values | byte... | The value to check. |
values | double... | The value to check. |
values | float... | The value to check. |
values | int... | The value to check. |
values | long... | The value to check. |
values | short... | The value to check. |
values | Byte[] | The value to check. |
values | Double[] | The value to check. |
values | Float[] | The value to check. |
values | Integer[] | The value to check. |
values | Long[] | The value to check. |
values | Short[] | The value to check. |
Returns
true
if the value parameter is not normal; false
otherwise.
Examples
The following example shows how containsNonFinite
interacts with various objects within a table.
source = newTable(
doubleCol("AllNulls", NULL_DOUBLE, NULL_DOUBLE),
doubleCol("AllNonNulls", 0.0, 0.1),
doubleCol("SomeNulls", 0.0, NULL_DOUBLE)
)
result = source.update(
"AllNullsResult = containsNonFinite(AllNulls_)",
"AllNonNullsResult = containsNonFinite(AllNonNulls_)",
"SomeNullsResult = containsNonFinite(SomeNulls_)"
)
- source
- result