Phone Number Normalization

Posted on 2008-06-26
Last Modified: 2012-08-13
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


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!


Question by:daveforster
  • 3
LVL 11

Expert Comment

ID: 21881790
(/d/d/d*$1) is what's as a "regular expression" ha go figure.
Also it's widely used not just microsoft.
LVL 11

Expert Comment

ID: 21881821
/d is shorthand for digit i think

here's a more detailed explaination:
LVL 11

Accepted Solution

MacNuttin earned 500 total points
ID: 21881868
$  is the "end of line" symbol. () is the grouping * is repitition

so I think /d/d/d*$1 means true when 3 digits over and over ending with 1

another link to drive you crazy:$

Author Closing Comment

ID: 31470909
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! ;)
LVL 31

Expert Comment

ID: 21886602
xxx xxxx xxxx

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

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Viewers will learn how to use the Hootsuite Dashboard.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now