REGEX_EXTRACT#
Extracts a group that matches the java-style regular expression regex.
A string function used in search operations for sophisticated pattern matching including repetition and alternation.
For more information on the Java format for regular expressions see the
java documentation.
Syntax#
REGEX_EXTRACT ( 'string' , 'regex' , group )
Arguments#
‘string’
Is the string to search for strings matching the regular expression. ‘string’ can be of a character data type.
‘regex’
Is the regular expression to match. ‘regex’ can be of a character data type.
group
Is a regular expression group number, defining which portion of the matching string to return. group can be of a integer data type.
Return types#
Returns nvarchar if one of the input arguments is of the nvarchar data type; otherwise, REGEX_EXTRACT returns varchar.
Returns NULL if any one of the arguments is NULL.
If string is not of type varchar(max) or nvarchar(max), REGEX_EXTRACT truncates the return value at 8,000 bytes. To return values greater than 8,000 bytes, string must be explicitly cast to a large-value data type.
Examples#
SELECT REGEXP_EXTRACT('1234567____123456', '\d{7}',0);