Link to home
Start Free TrialLog in
Avatar of daveforster
daveforsterFlag for Australia

asked on

Phone Number Normalization

Hey Guys!

Having a slight problem with Phone Number Normalization with LCS 2005.  The problem being is I haven't a clue about the string setup of the numbers!

I'm trying to get 2 strings setup for phone numbers in the UK.  The format I need is:

xxxxx xxxxxx

and

xxxx xxx xxxx

I've tried working out what (/d/d/d*$1) means but I'm afraid I can't speak Microsoft Martian!

Any help would be appreciated!

Cheers,

Dave
Avatar of MacNuttin
MacNuttin
Flag of United States of America image

(/d/d/d*$1) is what's as a "regular expression" ha go figure.
Also it's widely used not just microsoft.
/d is shorthand for digit i think

here's a more detailed explaination:
http://articles.techrepublic.com.com/5100-10878_11-5055982.html
ASKER CERTIFIED SOLUTION
Avatar of MacNuttin
MacNuttin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daveforster

ASKER

Thanks mate!  From the basis of this answer it seems that you have WAY too much time on your hands to be able to understand this! ;)

Worked a treat, simple but effective! ;)
xxx xxxx xxxx

is a valid UK phone number e.g., 020 7627 9234