λ Lambdas
Community lambdas.
Copyable definitions. Tested. Tagged. Star the ones you use.
REGEX.CAPTURE
(text, pattern, [group])
Capture a named regex group from a cell. Returns #N/A on no match, never the input.
TEXT.JSON.PARSE
(json, [path])
Parse a JSON string. Optional JSONPath ($..items[*].name). Returns spilled array.
TEXT.SLUGIFY
(s, [sep])
Lowercase, strip diacritics, replace non-alnum with the separator. Useful for stable keys.