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 |
---|---|
Returns a string that matches the given regular expression (which may be null if nothing matches. |
|
Returns an array containing all parts of the argument string that match the given regular expression (which may be empty if |
|
Return true if the argument input string or object (converted to a string) matches the argument regular expression. |
|
Coerce a string literal to a regular expression. |
|
Replaces all instances of a matched regex pattern in the input string with a provided value. |