Forum Discussion

AndrewAndrew2's avatar
AndrewAndrew2
Qrew Trainee
10 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
7 years ago
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
7 years ago
No error. I still get the (555)555-1212 and not 5555551212.