Formatting Text in Make Table Query

[KristenCarr]

I'm working with a Sybase table (through Access) which stores phone numbers as Text(25) formated as (XXX)XXX-XXXX. I need to change this to be XXX-XXX-XXXX for an export to another db. Formatting won't work since it won't know what to drop, I figure I should parse it but don't know how to do that in Access.

Any suggestions?

 

[itsmarkdavies]

1. Create another field in your Table (assuming you need to keep a copy of the data in it`s original format, if not just update the live data).

2. Create an Update Query on the Table you are using and update the Phone Number field to :-

Mid([TELNO],2,3) & "-" & Right([TELNO],8)

This would convert e.g. (020)123-4567 to 020-123-4567

Hope this helps.
itsmarkdavies@hotmail.com