How to avoid VBScript regular expression gotchasFri, Nov 4, 2005 in Programming
VBScript regular expressions are slightly troublesome, though they certainly help turn VBScript into less of a joke when it comes to text processing. The syntax lacks some of the niceties of Perl or .NET regexes, but is complete enough to be very useful. This article shows you how to avoid potentially serious problems, and explains an undocumented feature.
Undocumented and incorrect behavior
- The documentation is incomplete. The RegExp object has an undocumented property,
Multiline, which affects pattern matching using the
.metacharacter. This property’s default value is
.matches every character except a newline by default. When
True, the meaning of the
.metacharacter is different; it then matches every character including a newline. This is the same behavior you will find in other languages, such as Perl and .NET.
- Backslashed special characters do not work correctly inside brackets. For example, it ought to be possible to match across newlines with the patterns
[.\s]*, but this prevents the pattern from matching anything at all, even when no newlines are involved.
How to avoid memory leaks
There is a memory-leak bug which has been reported elsewhere on the Internet. An expression with more than 10 subexpressions in
Global mode can leak memory. To avoid this bug, don’t use a pattern with more than 10 subexpressions if the object’s
Global property is set to
Here are two links to the Microsoft VBScript RegExp documentation on MSDN:
I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and many open-source tools for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB.