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.

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.