Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 434
  • Last Modified:

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
0
daveforster
Asked:
daveforster
  • 3
1 Solution
 
MacNuttinCommented:
(/d/d/d*$1) is what's as a "regular expression" ha go figure.
Also it's widely used not just microsoft.
0
 
MacNuttinCommented:
/d is shorthand for digit i think

here's a more detailed explaination:
http://articles.techrepublic.com.com/5100-10878_11-5055982.html
0
 
MacNuttinCommented:
$  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:
http://www.troubleshooters.com/codecorn/littperl/perlreg.htm#op_$
0
 
daveforsterAuthor Commented:
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! ;)
0
 
moorhouselondonCommented:
xxx xxxx xxxx

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

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now