REGEXEXTRACT Function

text

(required)

The text or the reference to a cell containing the text you want to extract strings from.

pattern

(required)

The regular expression ("regex") that describes the pattern of text you want to extract.

return_mode

A number that specifies what strings you want to extract. By default, return mode is 0. The possible values are:

0: Return the first string that matches the pattern

1: Return all strings that match the pattern as an array

2: Return capturing groups from the first match as an array

Note: Capturing groups are parts of a regex pattern surrounded by parentheses "(...)". They allow you to return separate parts of a single match individually.

case_sensitivity

Determines whether the match is case-sensitive. By default, the match is case-sensitive. Enter one of the following:

0: Case sensitive

1: Case insensitive