regular expressions...

Mase · Jul 12th 2004

Ok, first of all... I'm sorry wasting (?) your time with such an elementary question, but I really don't find how to do this:
It's aboaut using reg expressions...

Code

Dim MyString as string
MyString="Blah Blah"
If MyString<> [COLOR=YellowGreen]*€[/COLOR] Then
    MsgBox (MyString & "doesn't end with €")
End if

My question is how do I make the program read the *€ as a regular expression?
Thank's very much in advance :thanx:

Jong · Jul 12th 2004

Regular expressions are used like this:

Code

'Init the regex
Dim MyExpression as Regex
Set MyExpression = new Regex


'Set its properties
MyExpression.Global = true
MyExpression.Pattern = "*€$"


'Other properties are available to you such as:
'MyExpression.IgnoreCase = true


'Test it against your string
if MyExpression.Test(MyString) = true then
    MsgBox "This string contains the regular expression"
else
    MsgBox "This String does not contain this regular expression"
end if

Display More

You will need to add a reference to "Microsoft VBScript Regular Expressions" in your VBA Editor > Tools > References.

For more help on Regex patterns, check out http://www.aivosto.com/vbtips/regex.html

regular expressions...

Participate now!

Share