OPAL Regex Functions

Regular expression functions use regular expressions as input.

Regular expressions in Observe must be compile time constants – they cannot be compiled based on data received from data streams.

Observe uses the POSIX flavor of the regular expression language, which is standard in data storage and processing. For more information, see:

• The Regular Expressions/POSIX Basic Regular Expressions Wikibook

• String Functions (Regular Expressions) in the Snowflake documentation

Function	Description
count_regex_matches	Returns the number of times the given regular expression pattern occurs in the argument string.
get_regex	Returns a string that matches the given regular expression if a match exists.
get_regex_all	Returns an array containing all parts of the argument string that match the given regular expression (which may be empty if
match_regex	Return true if the argument input string or object (converted to a string) matches the argument regular expression.
regex	Coerce a string literal to a regular expression.
replace_regex	Replaces all instances of a matched regex pattern in the input string with a provided value.