Jim Metcalf
asked on
Phone number data formatting all over the place in my database
I have a table that has a column for phone numbers. there are thousands in here and their formatting is not consistent.
ie....
(999) 999-9999
1111111111
222-222-2222
they are all over the place
I need to update this to one format. 888-888-8888 example
does someone know how to do that?
Thanks a bunch
ie....
(999) 999-9999
1111111111
222-222-2222
they are all over the place
I need to update this to one format. 888-888-8888 example
does someone know how to do that?
Thanks a bunch
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
it is only for USA numbers
Great, USA 10 digit numbers only. The +1 may be optional as an 11th digit. Between the solutions above, do you need any more assistance?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> I'd suggest not storing ANY formatting chars.
I second that. Like I mentioned earlier, my preference is to do formatting on the front end, or as Scott said when needed.
I second that. Like I mentioned earlier, my preference is to do formatting on the front end, or as Scott said when needed.
ASKER
PerfectoMundo
Do you need to support international numbers?