|
Rgx.LEN 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 length (or array of lengths) of the Nth substring matching the Regular Expression pattern.
Rgx.LEN is a multi-threaded, non-volatile array function.
Rgx.LEN 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 length 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.LEN Examples
.png)
|
