STRING Functions
All functions > STRING
All functions in the STRING category.
| Function | Description |
|---|---|
CHR | Converts a Unicode code point to its corresponding character. |
CODEPOINT | Returns the Unicode code point of the first character in a string. |
CONCAT_FUNC | Concatenates an array of strings into a single string. |
CONCAT_WS_FUNC | Concatenates an array of strings with a separator between each element. |
HAMMING_DISTANCE | Calculates the Hamming distance between two strings of equal length. |
LENGTH | Returns the number of characters in a string. |
LEVENSHTEIN_DISTANCE | Calculates the Levenshtein (edit) distance between two strings. |
LOWER | Converts all characters in a string to lowercase. |
LPAD | Left pads a string to a specified length with a padding string. |
LTRIM | Removes whitespace from the left (beginning) of a string. |
LUHN_CHECK | Validates a string using the Luhn algorithm (modulus 10 checksum). |
POSITION | Returns the position of the first occurrence of a substring within a string. |
REPLACE | Replaces all occurrences of a substring with another substring. |
REVERSE | Reverses the order of characters in a string. |
RPAD | Right pads a string to a specified length with a padding string. |
RTRIM | Removes whitespace from the right (end) of a string. |
SOUNDEX | Converts a string to its Soundex phonetic representation. |
SPLIT | Splits a string into an array of substrings based on a delimiter. |
SPLIT_PART | Returns a specific part of a string after splitting by a delimiter. |
STARTS_WITH | Checks if a string starts with a specified prefix. |
STRPOS | Returns the position of a substring within a string, optionally finding the N-th occurrence. |
SUBSTR | Extracts a substring from a string starting at a specified position. |
TRANSLATE | Replaces characters in a string based on character-to-character mappings. |
TRIM | Removes whitespace from both ends of a string. |
UPPER | Converts all characters in a string to uppercase. |
WORD_STEM | Returns the stem (root form) of a word using language-specific stemming rules. |
Summary
- Functions in STRING: 26
This documentation is automatically generated from the FeatureMesh registry.