Have you tried the UDF above?
Unfortunately notOriginally Posted by xld
From http://aspnet.4guysfromrolla.com/articles/022603-1.aspx
Lookaround is a feature that is partially implemented in JScript but not in VBScript. There are two directions of lookaround - lookahead and lookbehind - and two flavors of each direction - positive assertion and negative assertion. The syntax for each is:
(?=...) - Positive lookAHEAD
(?!...) - Negative lookAHEAD
(?<=...) - Positive lookBEHIND
(?<!...) - Negative lookBEHIND
Cheers
Dave