can you format a phone number to bring in 11 digits in mysql

Hi Experts,

Me again. I'm using Scriptcase and in the onvalidate event, i want to format what the user entered as digits in a phone number  to just bring in the digits, so if it is entered as 1 (931) 888-8888, i would like it to convert to 19318888888

How can i do this?

I have this
{FormatPhone}= Format({Phone}, 00000000000)

Is this the correct way?
Thanks :-)

Laura
linbayzakAsked:
Who is Participating?
 
cfEngineersConnect With a Mentor Commented:
{FormatPhone}= Format({Phone}, '\00000000000')
0
 
linbayzakAuthor Commented:
thanks, this works :-)
0
 
cfEngineersCommented:
Any time
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.