Use a regular expression to indicate a string that does not contain 2950

Use VBA in Excel to test the following (matching formula: ^ ((?! 2950).) * $ ):
Sub regs ()
Dim RegEx as object
Set RegEx = Createobject ("VBScript. Regexp ")
Dim S, mat
S = "399295078"
RegEx. pattern = "^ ((?! 2950).) * $"
RegEx. Global = true
Msgbox RegEx. test (s)
Set RegEx = nothing
End sub
If 2950 is matched, false is returned; otherwise, true is returned.
Where ,(?! 2950) does not match 2950,
^ Indicates the starting position of the matching string,
. Match any single character except "\ n,
$ Indicates the end position of the matched string,
* Indicates matching the previous subexpression zero or multiple times.
The entire matching formula is: match a null value or match a string without 2950.
Where (?! 2950) must be followed by a ".", then (?! 2950). It does not contain 2950 characters and must contain at least one character. In fact, the whole is (?! 2950) and (.) *, (.) * indicates an empty string or any other string (excluding \ n ).