Type functions
These are functions for detecting the type of data. These functions can be used in the directives filter-row-if-false
, filter-row-if-true
, filter-row-on
, or send-to-error
.
Pre-requisite
These can be used only in the filter-*
 or send-to-error
 directives.
Namespace
All type-related functions are in the namespace type
.
Example Data
Upload to the workspace body
 an input record such as:
{
"name": {
"fname": "Joltie",
"lname": "Root",
"mname": null
},
"date": "12/17/2019",
"time": "10:45 PM",
"boolean": "true",
"coordinates": [
12.56,
45.789
],
"numbers": [
1,
2.1,
3,
null,
4,
5,
6,
null
],
"moves": [
{ "a": 1, "b": "X", "c": 2.8},
{ "a": 2, "b": "Y", "c": 232342.8},
{ "a": 3, "b": "Z", "c": null},
{ "a": 4, "b": "U"}
],
"integer": "1",
"double": "2.8",
"empty": "",
"float": 45.6,
"aliases": [
"root",
"joltie",
"bunny",
null
]
}
Once such a record is loaded, apply these directives before applying any of the functions listed here:
parse-as-json :body
columns-replace 's/body_//g'
List of Type Functions
Each function returns true
 if the condition is met, false
 otherwise.
Function | Condition | Example |
---|---|---|
| Tests if string value is a date field |
|
| Tests if string value is a date time |
|
| Tests if string value is a booelan field |
|
| Tests if string value is a number field |
|
| Tests if string value is empty |
|
| Tests if string value is a double field |
|
| Tests if string value is an integer field |
|
Â
Created in 2020 by Google Inc.