Text functions
#
concatconcat(str, ...)
- concatenates a string from one or more input values.
Example
firstName | lastName | concat |
---|---|---|
Tim | Thompson | Tim Thompson |
Anna | Thompson | Anna Thompson |
Anna | Mason | Anna Mason |
Tom | Johnson | Tom Johnson |
Tim | Smith | Tim Smith |
tip
concat()
can be used to generate line protocol
. See example below.
Generating line protocol
#
lengthlength(string)
- reads length of string
value type (result is int
)
length(symbol)
- reads length of symbol
value type (result is int
)
length(blob)
- reads length of binary
value type (result is long
)
- a
string
- a
symbol
- a
binary
blob
Example
a | b |
---|---|
AARON | 5 |
AMELIE | 6 |
TOM | 3 |
null | -1 |
~=
~=(string, regex)
- matches string
value to regex
~=(symbol, regex)
- matches symbol
value to regex
#
!~!~(string, regex)
- checks if string
value does not match regex
!~(symbol, regex)
- checks if symbol
value does not match regex
#
to_lowercaseto_lowercase(string)
- converts all string characters to lowercase
#
to_uppercaseto_uppercase(string)
- converts all string characters to uppercase