FunctionsString
String
74 String functions in the NYXDB native function registry, with signatures, briefs, and measured medians where available.
74 functions in the string family. Each name links to its page; … marks the variadic argument list (the engine declares no named parameters). A Measured value appears only where a benchmark corpus case joins by name (server-class hardware, median).
| Function | Type | Description | Measured |
|---|---|---|---|
ascii(…) → UInt64 | scalar | ASCII code of first byte. | — |
ascii_as_blob(…) → String | scalar | ASCII-safe binary text. | — |
btrim(…) → String | scalar | Trim both ends of a string. | — |
chr(…) → String | scalar | Single-byte character from numeric code. | — |
concat(…) → String | scalar | Concatenate values into one string. | — |
concat_ws(…) → String | scalar | Concatenate values using a separator. | — |
ends_with(…) → Bool | scalar | Test whether a string ends with a suffix. | — |
initcap(…) → String | scalar | Title-case ASCII words. | — |
initcap_utf8(…) → Dynamic | scalar | Title-case UTF-8 words. | — |
left(…) → Dynamic | scalar | Take left part of a string. | — |
left_utf8(…) → Dynamic | scalar | Take left part of a UTF-8 string. | — |
length(…) → Dynamic | scalar | String length in bytes. | — |
length_utf8(…) → Dynamic | scalar | UTF-8 string length in code points. | — |
lower(…) → Dynamic | scalar | Lowercase string. | — |
lower_utf8(…) → Dynamic | scalar | Lowercase UTF-8 string. | — |
lpad(…) → Dynamic | scalar | Left-pad a string. | — |
lpad_utf8(…) → Dynamic | scalar | Left-pad a UTF-8 string. | — |
ltrim(…) → Dynamic | scalar | Trim characters from the left. | — |
overlay(…) → Dynamic | scalar | Overlay substring. | — |
overlay_utf8(…) → Dynamic | scalar | Overlay substring. | — |
position(…) → Dynamic | scalar | Find substring position. | — |
position_case_insensitive(…) → Dynamic | scalar | Find substring position (case-insensitive). | — |
position_case_insensitive_utf8(…) → Dynamic | scalar | Find substring position (case-insensitive). | — |
position_utf8(…) → Dynamic | scalar | Find substring position. | — |
regexp_count(…) → Dynamic | scalar | Count regular-expression matches. | — |
regexp_extract(…) → Dynamic | scalar | Extract by regular expression. | — |
regexp_instr(…) → Dynamic | scalar | Position of a regular-expression match. | — |
regexp_like(…) → Dynamic | scalar | Regular-expression match predicate. | — |
regexp_match(…) → Dynamic | scalar | First regular-expression match. | — |
regexp_matches(…) → Dynamic | scalar | All regular-expression matches. | — |
regexp_quote_meta(…) → Dynamic | scalar | Escape a string for regex literal use. | — |
regexp_replace(…) → Dynamic | scalar | Regular-expression replace. | — |
regexp_split_to_array(…) → String | scalar | Split string by regex into an array. | — |
regexp_split_to_table(…) → String | scalar | Split string by regex into rows. | — |
regexp_substr(…) → String | scalar | Regex substring. | — |
repeat(…) → String | scalar | Repeat a string. | — |
replace(…) → String | scalar | Substring replacement. | — |
replace_all(…) → String | scalar | Substring replacement. | — |
replace_one(…) → String | scalar | Substring replacement. | — |
replace_regex(…) → String | scalar | Regular-expression replacement. | — |
replace_regexp(…) → String | scalar | Regular-expression replacement. | — |
replace_regexp_all(…) → String | scalar | Regular-expression replacement. | — |
replace_regexp_one(…) → String | scalar | Regular-expression replacement. | — |
reverse(…) → String | scalar | Reverse a string. | — |
reverse_dns_query(…) → String | scalar | Reverse-DNS query name for an IP address. | — |
reverse_utf8(…) → String | scalar | Reverse a string. | — |
right(…) → String | scalar | Take right part of a string. | — |
right_utf8(…) → String | scalar | Take right part of a string. | — |
rpad(…) → String | scalar | Right-pad a string. | — |
rpad_utf8(…) → String | scalar | Right-pad a UTF-8 string. | — |
rtrim(…) → String | scalar | Trim characters from the right. | — |
split_by_alpha(…) → String | scalar | Split a string by alpha. | — |
split_by_char(…) → String | scalar | Split a string by char. | — |
split_by_non_alpha(…) → String | scalar | Split a string by non alpha. | — |
split_by_regexp(…) → String | scalar | Split a string by regexp. | — |
split_by_string(…) → String | scalar | Split a string by string. | — |
split_by_whitespace(…) → String | scalar | Split a string by whitespace. | — |
split_part(…) → String | scalar | Select a delimited field. | — |
starts_with(…) → Bool | scalar | Prefix test. | — |
strpos(…) → UInt64 | scalar | Find substring position. | — |
substring(…) → String | scalar | Substring. | — |
substring_index(…) → String | scalar | Substring up to a delimiter occurrence. | — |
substring_index_utf8(…) → String | scalar | Substring up to a delimiter occurrence. | — |
substring_utf8(…) → String | scalar | Substring. | — |
translate(…) → String | scalar | Character translation. | — |
translate_utf8(…) → String | scalar | Character translation. | — |
trim(…) → String | scalar | Trim characters from both ends. | — |
trim_array(…) → String | scalar | Trim whitespace for an array of strings. | — |
trim_both(…) → String | scalar | Trim characters from both ends. | — |
trim_left(…) → String | scalar | Trim characters from the left. | — |
trim_right(…) → String | scalar | Trim characters from the right. | — |
trim_scale(…) → String | scalar | Trim trailing zeros from a numeric string. | — |
upper(…) → String | scalar | Uppercase string. | — |
upper_utf8(…) → String | scalar | Uppercase UTF-8 string. | — |