Phone Number Split

G

Guest

In my query, I have a column with a phone number (000) 000-0000
It is a text field with a table input mask of !\(999) "000\-0000;0;_
I need to make three columns out of this, areacode, phone3,phone4
I don't want the ( ) in it.
Can someone help?
Thanks,
 
G

Guest

Works great.
Thanks


Rick B said:
AreaCode: Mid([Phone],2,3)
Phone3: Mid([Phone],7,3)
Phone4: Right([Phone[,4)


--
Rick B



Robert Smith said:
In my query, I have a column with a phone number (000) 000-0000
It is a text field with a table input mask of !\(999) "000\-0000;0;_
I need to make three columns out of this, areacode, phone3,phone4
I don't want the ( ) in it.
Can someone help?
Thanks,
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query by phone number 1
formatting a phone number in a string 2
Exporting a query to a spreadsheet 1
Input Mask question 2
input mask 5
Phone Number Formatting 8
Nz function 6
Input Mask For Phone Number 4

Top