coalesce(arg1,arg2,...,argN)
returns the value of the first of its input parameters that is not NULL
Accept Type(s): Arguments can be of any type, given that the argument count is more than zero and all the
arguments are of the same type.
The initialization method for StreamProcessor, which will be called before other methods and validate
the all configuration and getting the initial values.
split(sourceText, splitCharacter, returnedOutputPosition)
Splits the source String by splitCharacter and return the string in the index given by returnedOutputPosition
Accept Type(s): (STRING, STRING, INT)
Return Type(s): STRING
substr(sourceText, beginIndex) or substr(sourceText, beginIndex, length) or substr(sourceText, regex)
or substr(sourceText, regex, groupNumber)
Returns a new string that is a substring of this string.
tokenize(sourceText, delimiter)
Tokenize the source String by delimiters and return as tokens.
Accept Type(s): (STRING, STRING)
Return Type(s): STRING
unhex(str);
This is the equivalent of 'unhex' function in mysql 5.0
unhex(str) interprets each pair of characters in the argument as a hexadecimal number
and converts it to the byte represented by the number.