Uses of Class
dev.frostlake.functions.TextArgumentFunction

Packages that use TextArgumentFunction

Package	Description
dev.frostlake.functions.scalar.string

Uses of TextArgumentFunction in dev.frostlake.functions.scalar.string

Subclasses of TextArgumentFunction in dev.frostlake.functions.scalar.string

Modifier and Type	Class	Description
class	Ascii
class	BitLength
class	Char
class	CharIndex	CHARINDEX(needle, haystack [, start]) — POSITION's argument order; BINARY pairs search by BYTE.
class	Chr
class	Concat
class	ConcatWs
class	Contains
class	EditDistance
class	EndsWith
class	InitCap
class	Insert	INSERT(base, position, length, insertion).
class	JarowinklerSimilarity	JAROWINKLER_SIMILARITY(string1, string2) — the Jaro-Winkler similarity of the two strings scaled to an integer 0–100 (0 = no similarity, 100 = exact match), matching Snowflake.
class	Left	LEFT(expr, n) — the leading n characters of a VARCHAR, or the leading n BYTES of a BINARY.
class	Len
class	Length
class	Lower
class	LPad	LPAD(expr, len [, pad]) — a VARCHAR padded to len characters, or a BINARY padded to len BYTES.
class	LTrim
class	NormalizeFn	NORMALIZE(x, lo, hi) — Snowflake's min-max normalization (x - lo) / (hi - lo), NOT Unicode normalization (live-verified: NORMALIZE(5, 0, 10) is 0.5).
class	OctetLength
class	ParseIp	PARSE_IP(ip_address, type [, permissive]) — parses an IPv4/IPv6 address (optionally in CIDR addr/prefix form) into a VARIANT OBJECT, matching Snowflake.
class	ParseUrl	PARSE_URL(url [, permissive]) — parses a URL into a VARIANT OBJECT with Snowflake's keys, in ALPHABETICAL order (live-verified): fragment, host, parameters, path, port, query, scheme.
class	Position	POSITION(needle, haystack [, start]) — the 1-based position of needle, or 0 when absent.
class	RandStr	RANDSTR(length, generator) — a deterministic random alphanumeric string seeded by the generator.
class	RegexpCount	REGEXP_COUNT(subject, pattern [, position [, parameters]]) — the number of matches of pattern at or after position (1-based, default 1).
class	RegexpInstr	REGEXP_INSTR(subject, pattern [, position [, occurrence [, option [, parameters [, group_num]]]]]) — the 1-based position of the occurrence-th match (default 1) at or after position (default 1), or 0 when there is none.
class	RegexpLike	REGEXP_LIKE(subject, pattern [, parameters]) — TRUE when pattern matches the ENTIRE subject (implicitly anchored, as in Snowflake).
class	RegexpReplace	REGEXP_REPLACE(subject, pattern [, replacement [, position [, occurrence [, parameters]]]]) — replace matches of pattern with replacement.
class	RegexpSubstr	REGEXP_SUBSTR(subject, pattern [, position [, occurrence [, parameters [, group_num]]]]) — the occurrence-th match (default 1) at or after position (1-based, default 1).
class	RegexpSubstrAll	REGEXP_SUBSTR_ALL(subject, pattern [, position [, occurrence [, parameters [, group_num]]]]) — returns a VARIANT ARRAY with an element for every match at or after position (1-based, default 1), starting from the occurrence-th match (default 1).
class	Repeat	REPEAT(s, n): the string n times over, NULL when either argument is NULL.
class	Replace
class	Reverse	REVERSE(expr) — a VARCHAR reversed by characters, or a BINARY reversed by BYTES.
class	Right	RIGHT(expr, n) — the trailing n characters of a VARCHAR, or the trailing n BYTES of a BINARY.
class	RPad	RPAD(expr, len [, pad]) — a VARCHAR padded to len characters, or a BINARY padded to len BYTES.
class	RTrim
class	RtrimmedLength	RTRIMMED_LENGTH(s) — the length of the string without trailing blanks.
class	Soundex
class	Space	SPACE(n): n blanks.
class	Split	SPLIT(string, delimiter) — splits string on the literal delimiter into an ARRAY of substrings (rendered as a JSON array, the engine's VARIANT representation).
class	SplitPart
class	StartsWith
class	Strtok
class	StrtokToArray	STRTOK_TO_ARRAY(string [, delimiters]) — tokenizes string on any character in delimiters (each character is its own delimiter; the default is a single space) and returns a VARIANT ARRAY of the non-empty tokens.
class	Substring	SUBSTRING(expr, start [, length]) — a slice of a VARCHAR by characters or of a BINARY by BYTES.
class	Translate
class	Trim
class	TryParseIp	TRY_PARSE_IP — PARSE_IP that returns NULL instead of erroring on invalid input.
class	TryValidateUtf8	TRY_VALIDATE_UTF8(x) — the input as a string when its bytes are valid UTF-8, else NULL.
class	Unicode
class	Upper
class	ValidateUtf8	VALIDATE_UTF8(x) — the input as a string when its bytes are valid UTF-8.