OPAL String Functions

Function	Description
decode_base64	DecodeBase64 decodes a base64 encoded input
decode_uri	Replace %-encoded escape sequences in a string with…
decode_uri_component	Replace all %-encoded escape sequences in a string…
encode_base64	EncodeBase64 encodes the input in the base64 format
encode_uri	Replace certain characters in a string with %-encode…
encode_uri_component	Replace certain characters in a string with %-encode…
format_time	Format the timestamp value in UTC according to the…
left	Returns a leftmost substring of its input.
lower	Return the input string in lowercase.
lpad	Left pads a string with characters from another…
ltrim	ltrim removes leading characters from a string….
replace	Replaces all instances of the substring in the input…
replace_regex	Replaces all instances of a matched regex pattern in…
right	Returns a rightmost substring of its input.
rpad	Right pads a string with characters from another…
rtrim	rtrim removes trailing characters from a string….
split_part	Splits a given string at a specified character and…
strcat	Return the concatenation of all string arguments.
string_agg	Returns concatenated input values, separated by the…
substring	Extracts characters from a string, starting at an…
tokenize_part	Tokenizes the input string using the delimiter and…
trim	trim removes leading and trailing characters from…
upper	Return the input string in uppercase.