|
Regular Expression Functions
In addition to the Regular Expression Lookup functions FastExcel SpeedTools has Regular Expression functions for summing, counting and manipulating text:
Rgx.COUNTIF – count the number of cells that match a regular expression pattern
Rgx.SUMIF – sum cells whose corresponding cells match a regular expression pattern
Rgx.IsLike – returns True if the cell matches a regular expression pattern
Rgx.FIND – finds the position within a string that matches a regular expression pattern
Rgx.LEN – returns the length of the substring within a string that that matches a regular expression pattern
Rgx.MID – extracts text that matches a regular expression pattern
Rgx.SUBSTITUTE – replaces substring(s) that match a regular expression pattern with new text
These functions are all multi-threaded and have been built using the Boost Regular Expressions Library.
|
