Aivosto- RegExpr for VB & VBA

RegExpr is a regular expressions module for Visual Basic 6.0 and VBA.

 

What's in it? RegExpr for VB & VBA is a source code module with support for a full range of regular expressions. Implemented as pure VB or VBA source code, it does not require any additional run-time libraries.

 

When do I need it? RegExpr lets you use regular expressions in Visual Basic 6.0 and Office VBA as if they were built in the language itself.

 

How do I use it? You simply include RegExpr.bas in your project and start writing calls like this:

If RegExpr(Text, "[A-Z]*") Then...

 

Can I just use VB's built-in Like and Replace? Sure you can—if you're happy with the features they support. Regular expressions are much more. They can search for all character combinations, allow "Or" rules, verify the number of character occurrences, and support zero-width concepts such as word boundaries, end-of-line and "not followed by".

 

What's so great about RegExpr? RegExpr for VB & VBA implements a full range of regular expressions in pure source code. It doesn't require any external libraries or run-times. No DLLs to distribute.

 

Supported expressions

 

RegExpr supports a wide range of regular expression types. Here is a short list.

 

x* Zero or more x's

x+ One or more x's

x? One or zero x's

x{m,n} At least m and at most n x's

[A-Z] Any uppercase character A-Z

. Any single character except a newline

\w Any alphanumeric character

\d Any digit (the same as [0-9])

^ Start of string (or line)

 

RegExpr also supports advanced syntax such as:

 

x*? Stingy or minimal matching

\1 .. \9 Backreferences

(?=text) Positive lookaheads

(?!text) Negative lookaheads

 

System requirements

 

VB: Visual Basic and 6.0. Windows only.

VBA: Word, Excel, Access. Platform independent solution runs on Office for Windows and Mac.