AnsweredAssumed Answered

Phone number, zeros are omitted and replaced with #s

Question asked by wcallman on Apr 26, 2018
Latest reply on Apr 26, 2018 by mikebeargie

I am using the following to set the format of a phone number:

Let (A1_Emerg alt phone = Filter ( Self ; 1234567898 ) ;

Left (A1_Emerg alt phone; 3 ) & "-" & Middle (A1_Emerg alt phone; 4 ; 3 ) & "-" & Right (A1_Emerg alt phone; 4 )       )

 

The field is set to text, if a zero is entered it is replace by the next number.

 

8005551212,  should be. 800-555-1212, it shows855-512-1255.

 

Any thoughts?

Outcomes