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
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
Or if you want to keep it simple:

Left((NotLeft([Customer Cell Phone], "(")),")")&
Right((NotRight([Customer Cell Phone], "-")),3)&
Right([Customer Cell Phone], "-")
&"@"&
[Provider - Text Domain]