|
Rgx.MID function
Searches a string (or a rectangular array/range) for a substring that matches a regular expression patter (or a rectangular array/range of patterns).
Returns the Nth substring that matches the Regular Expression pattern.
Rgx.MID is a multi-threaded, non-volatile array function.
Rgx.MID Syntax
Rgx.MID (String, RegExp, Nth, Case_Sensitive)
The first 2 parameters are required; the last 2 parameters are optional.
String (required)
Constant, range or array containing the string(s) to be searched for the Regular Expression Patterns.
RegExp (required)
Specifies the Regular Expression(s) to be used when matching String. If String is an array or a multi-cell range then RegExp must contain a matching set (same number of rows and columns as String) of regular expressions
Nth (optional – default 1)
The Nth matching substring is returned.
A value of zero returns a horizontal array (row) containing all the matching substrings. In this case only a single string and single corresponding RegExp is allowed.
Case_Sensitive (optional)
TRUE to make the pattern-matching case-sensitive. The default is FALSE.
Rgx.MID Examples
.png)
|
