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 following information:

• The Regular Expressions/POSIX Basic Regular Expressions Wikibook

• String Functions (Regular Expressions) in the Snowflake documentation

Function	Description
get_regex	Returns a string that matches the given regular expression, which may be null if nothing matches.
get_regex_all	Returns an array containing all parts of the argument string that match the given regular expression, which may be empty if nothing matches.
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.