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.