Hi again,

Am Thu, 2 Apr 2015 09:47:12 -0700 schrieb Robert Crandal:

Can you explain how it works? All I see are
a couple of alternation "|" symbols and one
digit "\d" metacharater.

the alternation sign splits all characters in your string and the
characters are searched one by one.
If you want to do it with a pattern try:

ptrn = "[\(\d\)\d-\d!]"

can you post an example of Social Security numbers?
I don't know how they look like in your country.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional