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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
If your app took Google’s lash recently, here are the 5 most likely reasons.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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…

816 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

8 Experts available now in Live!

Get 1:1 Help Now