STRING Functions

All functions > STRING

All functions in the STRING category.

Case Conversion

Function	Description
LOWER	Returns the string with all characters converted to lowercase.
UPPER	Returns the string with all characters converted to uppercase.

Padding And Trimming

Function	Description
TRIM	Returns the string with whitespace from both ends removed.
LTRIM	Returns the string with whitespace from the left (beginning) removed.
RTRIM	Returns the string with whitespace from the right (end) removed.
LPAD	Returns the string padded on the left to a specified length with a padding string.
RPAD	Returns the string padded on the right to a specified length with a padding string.

Search String

Function	Description
STARTS_WITH	Returns TRUE if a string starts with a specified prefix.
ENDS_WITH	Returns TRUE if a string ends with a specified suffix.
POSITION	Returns the position of the first occurrence of a substring within a string.
STRPOS	Returns the position of a substring within a string, optionally finding the N-th occurrence.

Extraction String

Function	Description
SUBSTR	Returns a substring from a string starting at a specified position.
SPLIT	Returns an array of substrings from a string split by a delimiter.
SPLIT_PART	Returns a specific part of a string after splitting by a delimiter.

Transformation String

Function	Description
REVERSE	Returns the string with all characters in reverse order.
REPLACE	Returns the string with all occurrences of a substring replaced with another substring.
TRANSLATE	Returns a string with character-level replacements applied based on character-to-character mappings.

Concatenation

Function	Description
CONCAT	Returns a single concatenated string from a list of strings.
CONCAT_WS	Returns a concatenated string from a list of strings with a separator between each element.

Character

Function	Description
LENGTH	Returns the number of characters in a string.
CHR	Returns the character corresponding to the given Unicode code point.
CODEPOINT	Returns the Unicode code point of the first character in a string.

Distance

Function	Description
HAMMING_DISTANCE	Returns the Hamming distance between two strings of equal length.
LEVENSHTEIN_DISTANCE	Returns the Levenshtein (edit) distance between two strings.

Phonetic

Function	Description
WORD_STEM	Returns the stem (root form) of a word using language-specific stemming rules.
SOUNDEX	Returns a four-character Soundex code representing the phonetic sound of a string.

Validation String

Function	Description
LUHN_CHECK	Returns TRUE if a string passes the Luhn algorithm (modulus 10 checksum).

Hash

Function	Description
MD5	Returns the MD5 hash of a string as a 32-character hexadecimal string.
SHA1	Returns the SHA-1 hash of a string as a 40-character hexadecimal string.
SHA256	Returns the SHA-256 hash of a string as a 64-character hexadecimal string.

Regex

Function	Description
REGEX_CONTAINS	Returns TRUE if a string contains a match for a regular expression pattern.
REGEX_EXTRACT_FIRST	Returns the first substring matching a regular expression pattern, optionally extracting a specific...
REGEX_EXTRACT_ALL	Returns an array of all substrings matching a regular expression pattern.
REGEX_REPLACE_FIRST	Returns the string with the first occurrence of a regular expression pattern replaced.
REGEX_REPLACE_ALL	Returns the string with all occurrences of a regular expression pattern replaced.

---

Summary

• Functions in STRING: 35

This documentation is automatically generated from the FeatureMesh registry.