DENULLIFY
Syntax
DENULLIFY(<any>; <any>)
Description
Converts null values (represented by ω) to non-null default values. All non-null values are left untouched.
Integer null values are converted to 0 (zero), float values are converted to 0.0, string null values are converted to empty strings, Boolean values are converted to false, and null date values are converted to Jan 1, 1970 12:00:00 AM.
An additional argument can be entered into DENULLIFY as a default replacement to null values.
Examples
Example 1
=DENULLIFY(#Column1)
| Data field type | Column1 | DENULLIFY returns |
|---|---|---|
| Integer | 1 | 1 |
| Integer | null (ω) | 0 |
| Integer | 3 | 3 |
| Float | 1.1 | 1.1 |
| Float | null (ω) | 0.0 |
| Float | 2.2 | 2.2 |
| Date | Sep 19, 2008 11:13:27 AM | Sep, 19 2008 11:13:27 AM |
| Date | null (ω) | Jan, 01 1970 12:00:00 AM |
| Date | Nov, 25 2010 11:56:13 AM | Nov, 25 2010 11:56:13 AM |
| String | "test1" | “test1" |
| String | null (ω) | "" (an empty string) |
| String | "test3" | "test3" |
| Boolean | true | true |
| Boolean | null (ω) | false |
| Boolean | false | false |
| List | null | [ ] (empty list) |
| List | [1,2,3] | [1,2,3] |
Example 2
=DENULLIFY(#Column1;"123456789")
| Data Field Type | Column1 | Returns |
|---|---|---|
| Integer | null (ω) | 123456789 |