Is there a way to do negative and positive lookbehind in VBA regex?
I want to not match if the string starts with "A", so I am currently doing ^A at the start of the pattern, then removing the first character of match(0). Obviously not the best method!
I am using the regExp object.
VBA offers lookahead (both positive and negative) but rather inconsistently not lookbehind.
The best example of using Regex with VBA that I have seen is this article by Patrick Matthews.
[Updated example using
Execute
rather thanReplace
]While I am not completely clear on your usage you could use a function like this:
(
and)
is the first submatch).To understand the complete pattern, you may refer to the explanation on regex101.