I have a phone number and fax number field within my database. People will enter all of the following formats:
(xxx) xxx-xxxx
xxx-xxx-xxxx
xxx xxx xxxx
xxx xxx-xxxx
Is there any way to take any data input into these fields and force it to my desired format of xxx-xxx-xxxx (as long as it has 10 digits)?
Thanks.
(xxx) xxx-xxxx
xxx-xxx-xxxx
xxx xxx xxxx
xxx xxx-xxxx
Is there any way to take any data input into these fields and force it to my desired format of xxx-xxx-xxxx (as long as it has 10 digits)?
Thanks.