String Functions (Lakehouse v2)
This section provides reference information for the string functions in PlaidCloud Lakehouse.
Functions
Section titled “Functions”- APPEND_TRAILING_CHAR_IF_ABSENT
- ASCII
- CHAR_LENGTH
- CHAR
- CHARACTER_LENGTH
- CONCAT_WS
- CONCAT
- CRC32
- ENDS_WITH
- FIELD
- FIND_IN_SET
- FORMAT_BYTES
- GROUP_CONCAT
- HEX_DECODE_BINARY
- HEX_DECODE_STRING
- HEX
- INET_ATON
- INITCAP
- INSTR
- LCASE
- LEFT
- LENGTH
- LOCATE
- LOWER
- LPAD
- LTRIM
- MONEY_FORMAT
- NGRAM_SEARCH
- NULL_OR_EMPTY
- PARSE_URL
- REGEXP_SPLIT
- REPEAT
- REPLACE
- REVERSE
- RIGHT
- RPAD
- RTRIM
- SPACE
- SPLIT_PART
- SPLIT
- STARTS_WITH
- STR_TO_MAP
- STRCMP
- STRLEFT
- STRPOS
- STRRIGHT
- SUBSTR
- SUBSTRING_INDEX
- SUBSTRING
- TOKENIZE
- TRANSLATE
- TRIM
- UCASE
- UNHEX
- UPPER
- URL_DECODE
- URL_ENCODE
- URL_EXTRACT_HOST
- URL_EXTRACT_PARAMETER