|
Rgx.FIND function
Searches a string (or a rectangular array/range) for a substring that matches a regular expression pattern (or a rectangular array/range of patterns).
Returns the position (or array of positions) of the Nth substring matching the Regular Expression pattern.
Rgx.FIND is a multi-threaded, non-volatile array function.
Rgx.FIND Syntax
Rgx.FIND(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 start position of the Nth match of the substring is returned.
Case_Sensitive (optional)
TRUE to make the pattern-matching case-sensitive. The default is FALSE.
Rgx.FIND Examples
.png)
|
