Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
regEx replace
If a substring is found that matches my regular expression
pattern, I would like each character to be replaced with a "*" character. I thought the following code would work, but I'm missing something? : '-------------------------------------------------------- Sub myregex() Dim regEx As New VBScript_RegExp_55.RegExp Dim str As String str = "Call me at (982)555-1234!" regEx.Pattern = "(...)...-...." regEx.Global = True regEx.IgnoreCase = True MsgBox regEx.Replace(str, "*") End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regex Pattern | Excel Programming | |||
Regex as replace function | Excel Programming | |||
Help with a regex pattern please | Excel Programming | |||
Help with a Regex Pattern | Excel Programming | |||
Regex techniques | Excel Programming |