Phone Number Split

[Robert Smith]

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,

 

[Rick B]

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

 

[Robert Smith]

Works great.
Thanks

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


--
Rick B

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,