Regular Expressions: [!0-9] does not work???

tinfanide · #1 05-29-2012, 06:23 AM

Code:

Sub test()

Dim str As String
str = "str 9999 9999 str"

Dim RegExp As Object
Set RegExp = CreateObject("vbscript.regexp")

With RegExp
    .IgnoreCase = True
    .MultiLine = False
    .Pattern = "[!0-9]"
    .Global = True
End With

output = RegExp.Replace(str, "")
MsgBox output

Set RegExp = Nothing

End Sub

I can't understand why [a-z] can extract the numbers but why [!0-9] can't.

Colin Legg · #2 05-29-2012, 09:14 AM

I think you mean to use this:

Code:

.Pattern = "[^0-9]"

Which could be simplified to:

Code:

.Pattern = "\D"

tinfanide · #3 05-29-2012, 06:57 PM

Exactly. Thanks for reminding me about the use of "\D".

Just wonder why the tutorial below says this:
http://www.gmayor.com/replace_using_wildcards.htm
Under the "[!]" section, it says "!" means "NOT". Does VBA regular expressions share a different set of symbols from "Find and Replace" regular expressions?

Colin Legg · #4 05-30-2012, 01:21 AM

Hi,

That find and replace tutorial is for using Microsoft Word's find and replace tool. Regex has it's own set of wildcards and special characters, examples:

http://www.aivosto.com/vbtips/regex.html

tinfanide · #5 05-30-2012, 04:09 AM

Thank you for the reference.
It adds more to my programming library...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
work vs regular work. and how regular work works	user0044	Project	5	03-06-2012 07:28 AM
regular Expressions Formatting for Search	sesproul	Mail Merge	1	11-30-2011 05:02 AM
Access 2003 says unsafe expressions not blocked, but only some users on same computer	ZLA	Office	3	07-23-2010 10:00 AM
Issue skipping characters by Regular Expressions in Word	pochtara	Word VBA	0	04-01-2010 05:37 AM
How do I have headers and footers appear as regular text for the whole document?	user908045	Word	0	03-13-2010 12:41 PM