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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Let’s list some of the technologies that enable smooth teleworking. 
Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

751 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