Skip to main content

Regular Expressions

Function NameDescription
REGEXP_EXTRACTExtracts the first string in expression that matches the REGEXP expression and corresponds to the REGEX group index.
REGEXP_LIKEReturns true when the specified regular expression matches values in a column. Otherwise, returns false.
REGEXP_MATCHESReturns true when the specified regular expression matches values in a column. Otherwise, returns false.
REGEXP_REPLACEFinds strings that match the given regular expression and replaces the strings with the given string.
REGEXP_SPLITSplits an input string by using a regular expression according to a keyword and an integer value.