regexp_extract_all() function
The regexp_extract_all() function returns, in a varchar or nvarchar array, all matching text items.
Syntax
The regexp_extract_all() function has the following
syntax:
array(varchar) = regexp_extract_all(varchar input, varchar pattern
[, int start_pos] [, varchar flags]);
array(nvarchar) = regexp_extract_all(nvarchar input, nvarchar pattern
[, int start_pos] [, varchar flags]);
The input
value specifies the
varchar
or nvarchar value against which the regular expression
is processed.
The pattern
value specifies the regular expression. For a
description of how to specify Perl compatible regular expression (PCRE) patterns for Unicode data,
see any general PCRE documentation or web sources.
The start_pos
value specifies
the character position at which
to start the extract. The default is 1.
For a description of the flags
value, see flags argument.
Returns
The function returns all matching text items.Example
select array_combine(regexp_extract_all('Steven .Stephen is the best
player','Ste(v|ph)en'),'|');
ARRAY_COMBINE
----------------
Steven|Stephen
(1 row)