Functions

REGEXEXTRACT

Extract first regex match from text

Try it

When to use it

When should I use REGEXEXTRACT?

Use REGEXEXTRACT to pull out the first substring that matches a regular expression pattern, such as extracting a product code or phone number from unstructured text.

Used in

operations · sales

Syntax

REGEXEXTRACT(text, pattern)

REDUCE

Reduces an array to a single value using a LAMBDA

REGEXMATCH

True if text matches regex pattern