Regular Expressions

Function Name Description

Function Name	Description
REGEXP_EXTRACT	Extracts the first string in expression that matches the `REGEXP` expression and corresponds to the `REGEX` group index.
REGEXP_LIKE	Returns `true` when the specified regular expression matches values in a column. Otherwise, returns `false`.
REGEXP_MATCHES	Returns `true` when the specified regular expression matches values in a column. Otherwise, returns `false`.
REGEXP_REPLACE	Finds strings that match the given regular expression and replaces the strings with the given string.
REGEXP_SPLIT	Splits an input string by using a regular expression according to a keyword and an integer value.

Extracts the first string in expression that matches the REGEXP expression and corresponds to the REGEX group index.

Returns true when the specified regular expression matches values in a column. Otherwise, returns false.

Returns true when the specified regular expression matches values in a column. Otherwise, returns false.

Finds strings that match the given regular expression and replaces the strings with the given string.

Splits an input string by using a regular expression according to a keyword and an integer value.

Last updated 1 year ago