Links

String functions

This section describes the following string functions:
  • 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 String to Date
  • JOIN_ARRAYS: Joins any number of arrays by index using a MessageFormat pattern
  • LENGTH: Gets 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 string into a timestamp with time zone using format
  • REPLACE: Replaces all instances of search with replace in input. If 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
  • SHA512: Hashes the input using SHA-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 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 substring in string. Positions start with 1. If not found, 0 is returned.
  • SUBSTR: Returns a substring from string of length length from the starting position start. Positions start with 1. A negative starting position is interpreted as being relative to the end of the string.
  • SUBSTRING: Returns a substring from string of length length from the starting position start. Positions start with 1. A negative starting position is interpreted as being relative to the end of the 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