Formula Playground
Copy base
Report abuse
Views
Autonumber
Formula Reference
Description (from Formula Reference)
Type (from Formula Reference)
1
1
REGEX_MATCH()

Returns whether the input text matches a regular expression.

Logical functions
2
2
REGEX_EXTRACT()

Returns the first substring that matches a regular expression.

Text functions
3
3
REGEX_REPLACE()

Substitutes all matching substrings with a replacement string value.

Text functions
Drag to adjust the number of frozen columns
Example Text
REGEX_MATCH(string, regex)
REGEX_EXTRACT(string, regex)
REGEX_REPLACE(string, regex, replacement)
The world says hello back.
1
#ERROR!
world says hello back.
The wild goose chase
0
goose chase
wild goose chase
The Biggest Gopher
0
ggest Gopher
Biggest Gopher
3 records
  • All — use the below views to filter between examples!
  • REGEX_MATCH()
  • REGEX_EXTRACT()
  • RECORD_REPLACE()
Extensions

Alert

Lorem ipsum
Okay