I've just started using VBA and need to work with regular expression.
Does anybody know what's the symbol in VBA regex for ? " or !
I have this regular expression
[vba]regEx.Pattern = "([?!.,]+)(\d+)([\s\b\w*\b]?)"[/vba]
This regular expression should find:
blablabla.78 blablabla >> .78
blablabla?"129 >> ?"129
blablabla!1 >> !1
but when I run it, it only recognize . and , but not ? or !
And for the case " I used ascii code and it doens't find it as well.
Does anybody know how to do this?