Entering Phone Numbers

[LinuxGuy]

Can someone PostSome Code on Entering In a Phone Number w/ spaces or dashes such as 1 675 676 6765 or
1-712-876-6765 and have it go into the database that way thru ASP using Access> ?? im having tons of trouble with this

 

[shaddow]

Can use one of this things.
I dont knw the simpliest method but this works 100% to

myPhone="1 675 676 6765"
set regEx=new RegExp
regEx.Pattern="[0-9] [0-9][0-9][0-9] [0-9][0-9][0-9] [0-9][0-9][0-9][0-9]"
regEx.IgnoreCase = True
regEx.Global = True   
set rez=regEx.Execute(myPhone)
if rez.Count<>0 then 
'it's ok
end if

and

regEx.Pattern=&quot;[0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]&quot;
regEx.IgnoreCase = True
regEx.Global = True   
set rez=regEx.Execute(myPhone)
if rez.Count<>0 then 
'it's ok
end if

________
George, M

 

[dbMark]

Here are some threads in 3 forums: ASP, VBScript and JavaScript. There may be more threads out there too. Regular Expression structure is identical (or nearly so) between VBScript (what ASP commonly uses) and JavaScript (popular on browser-side pages).

thread333-643879
thread329-628813
thread216-572361
thread216-417788
thread216-269561
thread216-79176