Search Results for: String instruments
and returns the resulting string. if the nullstring parameter is omitted or null, any null elements in the array are simply skipped and not represented in the output string. example: array_to_string(my_array_col, my_delimiter_col, my_null_string_col) array_to_string(array['a','b','c'], ',') evaluates
starting at the one-based position. if zero is used, the position is zero-based. if the start index is negative, then the start index is relative to the end of the string. the length is optional and if not supplied, the rest of the string will be returned. example: substr('[hello]', , ) substr('hello...
https://phoenix.apache.org/language/functions.html