OPAL String Functions

String functions process strings as input or provide strings as output.

Function	Description
array_to_string	Cast all values in an array to string and concatenate them, optionally adding a separator between each value.
decode_base64	DecodeBase64 decodes a base64 encoded input
decode_uri	Replace %-encoded escape sequences in a string with unencoded plain text.
decode_uri_component	Replace all %-encoded escape sequences in a string with unencoded plain text.
encode_base64	EncodeBase64 encodes the input in the base64 format
encode_uri	Replace certain characters in a string with %-encoded escape sequences.
encode_uri_component	Replace certain characters in a string with %-encoded escape sequences.
format_time	Format the timestamp value in UTC according to the specified format.
get_regex	Returns a string that matches the given regular expression (which may be null if nothing matches.
left	Returns a leftmost substring of its input.
lower	Return the input string in lowercase.
lpad	Left pads a string with characters from another string, default pad string is whitespace
ltrim	ltrim removes leading characters from a string.
replace	Replaces all instances of the substring in the input string with a provided value.
replace_regex	Replaces all instances of a matched regex pattern in the input string with a provided value.
right	Returns a rightmost substring of its input.
rpad	Right pads a string with characters from another string, default pad string is whitespace
rtrim	rtrim removes trailing characters from a string.
split_part	Splits a given string at a specified character and returns the requested part.
string_agg	Returns concatenated input values, separated by the delimiter.
string_agg_distinct	Returns concatenated input values, separated by the delimiter.
string_concat	Return the concatenation of all string arguments.
substring	Extracts characters from a string, starting at an index.
tokenize_part	Tokenizes the input string using the delimiter and returns the requested part.
trim	trim removes leading and trailing characters from a string.
upper	Return the input string in uppercase.