All — use the below views to filter between examples!
Hide fields
Filter
Group
Sorted by 1 field
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
Sum
6
Summary
Summary
Summary
Summary
Sum
1
Summary
Summary
All — use the below views to filter between examples!
REGEX_MATCH()
REGEX_EXTRACT()
RECORD_REPLACE()
Extensions
Overview
Formula Playground Instructions
Number of functions and operators
Alert
Lorem ipsum
Okay
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key