Phone Number Split

  • Thread starter Thread starter Guest
  • Start date Start date
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,
 
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...
 
Back
Top