AnsweredAssumed Answered

Phone Number Input Mask Modification

Question asked by bleyden on Sep 1, 2018
Latest reply on Sep 2, 2018 by fmpdude

Hi All,

 

I use an input mask (from the FileMaker KB) to format phone numbers to have parentheses, etc.  The result is (###)###-####.  Is there anything that can be done to the calculation to have a space between ) and the next number, resulting in (###) ###-####?

 

Choose(Length(PhoneNumber);

"(###)###-####";

"("&PhoneNumber&"##)###-####";

"("&PhoneNumber&"#)###-####";

"("&PhoneNumber&")###-####";

"("&Left(PhoneNumber;3)&")"&Middle(PhoneNumber;4;1)&"##-####";

"("&Left(PhoneNumber;3)&")"&Middle(PhoneNumber;4;2)&"#-####";

"("&Left(PhoneNumber;3)&")"&Middle(PhoneNumber;4;3)&"-####";

"("&Left(PhoneNumber;3)&")"&Middle(PhoneNumber;4;3)&"-"&Middle(PhoneNumber;7;1)&"###";

"("&Left(PhoneNumber;3)&")"&Middle(PhoneNumber;4;3)&"-"&Middle(PhoneNumber;7;2)&"##";

"("&Left(PhoneNumber;3)&")"&Middle(PhoneNumber;4;3)&"-"&Middle(PhoneNumber;7;3)&"#";

"("&Left(PhoneNumber;3)&")"&Middle(PhoneNumber;4;3)&"-"&Middle(PhoneNumber;7;4))

Outcomes