Thread: regEx replace
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default regEx replace

"Claus Busch" wrote:
Hi again,

str = "Call me at (982)555-1234!"
ptrn = "\(|\)|-|!|\d"


Wow, I never woulda guessed that expression.
Can you explain how it works? All I see are
a couple of alternation "|" symbols and one
digit "\d" metacharater.

Also, what pattern works for Social Security
numbers?