[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2011-05-06
3
Medium Priority
?
474 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:linbayzak
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
cfEngineers earned 2000 total points
ID: 35708982
{FormatPhone}= Format({Phone}, '\00000000000')
0
 

Author Closing Comment

by:linbayzak
ID: 35709495
thanks, this works :-)
0
 
LVL 6

Expert Comment

by:cfEngineers
ID: 35712044
Any time
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month19 days, 20 hours left to enroll

872 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