String Functions

Function	Syntax	Description
find()	`find(string expr field, string find)`	Returns the index value of the first occurrence of a `string` within another `string`
findLast()	`findLast(string expr field, string find)`	Returns the index of the last substring match
substring()	`substring(string expr field, int start, [int end])`	Returns a substring from a string expression
splitPart()	`splitPart(string delimited_string, string delimiters, int index)`	Returns an element of a delimited `string`
replace()	`replace(string field, string old, string new)`	Returns a string with old substrings replaced by new substrings

Function	Syntax	Description
lower()	`lower(string expr str)`	Returns its `string` argument in all lower case
upper()	`upper(string expr str)`	Returns its `string` argument in all upper case

Function	Syntax	Description
lTrim()	`lTrim(string str)`	Returns its `string` argument without any leading white space
rTrim()	`rTrim(string str)`	Returns its `string` argument without any trailing whitespace
trim()	`trim(string str)`	Returns its `string` argument without leading or trailing whitespace

Function	Syntax	Description
ifNull()	`ifNull(string expr str1, string expr str2)`	Returns one of two expressions depending on whether one of the expressions is NULL
length()	`length(string expr str)`	Returns the length of a string
bin()	`bin(series, label_a, limit, label_b)`	Splits data values based on specified criteria
concat()	`concat(string str1, string str2, . . ., string strN)`	Returns the concatenation of an arbitrary number of string expressions
repeat()	`repeat(string str, int rep)`	Returns str repeated rep times
reverse()	`reverse(string str)`	Returns str reversed