MicrosoftI am exceptionally eager to try my hand at these new functions!
BTW, it sure would be nice to get some Regular Expressions-powered functions! Some ideas:
RegExpFind: Given input and pattern strings, return an array of the items matching the pattern string
RegExpSubmatchFind: Given input and pattern strings, return a 2-D array of the items matching the pattern string, split out into the submatches. For example, if the pattern string has three "parts" and there were three matches, the returned array is 3x3
RegExpReplace: Given input, pattern, and replacement strings, return a result string in which the matches are replaced in the input by the replacement string
I've used by own UDFs for these for years, based on the VBScript RegExp class, and I'd be happy to elaborate further and share examples.
