String

This section describes the following string functions:

Function	Description
BASE64_DECODE	Decode a base 64 string into a string
BASE64_TO_HEX	Converts a base 64 string into a hex string
BYTES_SUBSTRING	Returns a substring of the input, using the offsets in bytes of the UTF-8 encoded byte representation. Partial characters and invalid UTF-8 code points are removed from the result
CONCAT	Returns the concatenation of string1, string2, ..., stringN
DATE	Casts a string to a date
JOIN_ARRAYS	Joins any number of arrays by index using a MessageFormat pattern
LENGTH	Returns the length of the string
LOWER	Converts the string to lowercase letters
LPAD	Pad the input string to the left with a given padding string up until size
LTRIM	Returns the given string without leading whitespaces
MD5	Hashes the input using MD5
PARSE_DATETIME	Parses a string into a timestamp with time zone using a format
REPLACE	Replaces all instances of search with replace in input. If the search is empty, inserts replace in front of every character and at the end of the input
REVERSE	Returns a string with the characters in reverse order
RPAD	Pad the input string to the right with a given padding string up until size
RTRIM	Returns the given string without trailing whitespaces
SHA1	Hashes the input using SHA-1
SHA256	Hashes the input using SHA-256
SHA3_512	Hashes the input using SHA3-512
SORT_VALUES	Returns the values sorted in dictionary order
SPLIT	Returns the given string split by the provided delimiter. Does not remove empty entries
SPLIT_TO_RECORD	Returns the given string split by the provided delimiter
STRING_FORMAT	Format any number of inputs into a string using the given format
STRIP_MARGIN	For each line remove the prefix of control or whitespace characters followed by the given margin char
STRIP_PREFIX	Remove the given prefix string from the beginning of the string
STRIP_SUFFIX	Remove the given suffix string from the end of the string
STRPOS	Returns the starting position of the first instance of a given substring within a string
SUBSTR	Extracts a substring of a certain length starting from a specified point within the given string
SUBSTRING	Extracts a substring of a certain length starting from a specified point within the given string
TRANSLATE	Translates the given value using a given dictionary
TRIM	Returns the given string without leading or trailing whitespaces
TRIM_CHARS	Returns the given string without leading or trailing characters
UPPER	Converts the string to uppercase letters
UUID_GENERATOR	Returns UUID
XX_HASH	Hashes the input using xxHash