Validate text filed to display phone number in (999) 999-9999 format

Question

I want to input the mobile number in the Text field after saving the record the mobile number should display in (999) 999-9999 format.

I've tried creating a formula field of text and gave the below formula

SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE( Phone__c ,
 '.', NULL),
 ' ', NULL), 
'-', NULL), 
')', NULL),
 '(', NULL)

But it doesn't work for me. Can anyone help me doing this?

Try this regex ^[(]{0,1}[0-9]{1,4}[)]{0,1}[-\s\./0-9]*$ here regexr.com/3c53v — Ratan Paul, Commented Feb 4, 2020 at 14:09

Ratan Paul · Accepted Answer · 2020-02-04 14:09:35Z

1

Try this regex ^[(]{0,1}[0-9]{1,4}[)]{0,1}[-\s./0-9]*$

answered Feb 4, 2020 at 14:09

Ratan Paul

22.8k14 gold badges55 silver badges99 bronze badges

Add a comment |

1 Answer 1