daveforster
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
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
/d is shorthand for digit i think
here's a more detailed explaination:
http://articles.techrepublic.com.com/5100-10878_11-5055982.html
here's a more detailed explaination:
http://articles.techrepublic.com.com/5100-10878_11-5055982.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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! ;)
Worked a treat, simple but effective! ;)
xxx xxxx xxxx
is a valid UK phone number e.g., 020 7627 9234
is a valid UK phone number e.g., 020 7627 9234
Also it's widely used not just microsoft.