how to exclude digits using regular expression in VBA-CodePudding

Hello I need to exclude sequence of digits from 890000 till 890001;

890002 to 899999 is acceptable

Is it possible doing using regular expression?

CodePudding user response：

No need for regex.

If Value >= 890002 And Value <= 899999 Then
    ' Accept
End If

CodePudding user response：

Ok, if you insist on using regex (may be for learning purpose):

In this simple case it is actually easier to exclude those two number and match the rest:

^89(?!000[12])\d{4}$

Explanation:

^ match from start of text

89match 89

(?!000[12]) negative look ahead for 3 times zero and one of characters in the character group (1 or 2). If this doesn't block the match:

\d{4} match 4 digits

$ match end of text.