Forum Discussion

AndrewAndrew2's avatar
AndrewAndrew2
Qrew Trainee
9 years ago

Converting a QB entered/formatted Phone number to a 10-digit number

I have a Phone Number Field that the user enters a phone number into. QB returns with a formatted number in the following format: (555) 555-1212 I am using this number in an Email field to send a...
Forms
NotificationsEmail
Tables and fields
CassieHubble's avatar
CassieHubble
Qrew Cadet
I can not for the life of me get this to work. 

List("",
Part([Guardian-Cell Number],1, "() -"),
Part([Guardian-Cell Number],2,  "() -"),
Part([Guardian-Cell Number],3,  "() -"),
Part([Guardian-Cell Number],4,  "() -"),
Part([Guardian-Cell Number],5,  "() -"),
Part([Guardian-Cell Number],6,  "() -"))

Striped Cell Number
(555) 555-1212
CassieHubble's avatar
CassieHubble
Qrew Cadet
6 years ago
It's a phone number field. I was finally able to get Matthew Neil suggestion to work. Thank you so much for your help.