6diegodiego9
Board Regular
- Joined
- Jan 9, 2018
- Messages
- 80
- Office Version
- 2016
- Platform
- Windows
The official regular expressions library in VBA is Microsoft VBScript Regular Expressions 5.5.
Unfortunately, as well described here VBScript RegExp Object - Using Regular Expressions with Client Side Scripting, it lacks quite a number of advanced features available in Perl and other modern regular expression flavors:
Has anyone ported one of these engines as a library for VBA?
Unfortunately, as well described here VBScript RegExp Object - Using Regular Expressions with Client Side Scripting, it lacks quite a number of advanced features available in Perl and other modern regular expression flavors:
- "No \A or \Z anchors to match the start or end of the string. Use a caret or dollar instead.
- Lookbehind is not supported at all. Lookahead is fully supported.
- No atomic grouping or possessive quantifiers
- No Unicode support, except for matching single characters with \uFFFF
- No named capturing groups. Use numbered capturing groups instead.
- No mode modifiers to set matching options within the regular expression.
- No conditionals.
- No regular expression comments. Describe your regular expression with VBScript apostrophe comments instead, outside the regular expression string."
Has anyone ported one of these engines as a library for VBA?