Returns whether the input text matches a regular expression.
Returns the first substring that matches a regular expression.
Substitutes all matching substrings with a replacement string value.
REGEX_REPLACE(string, regex, replacement)
REGEX_REPLACE("Hello World", " W.*", "") => "Hello"