AnsweredAssumed Answered

Formatting International Numbers

Question asked by rickaltman on Oct 15, 2018
Latest reply on Oct 16, 2018 by beverly

I have a nifty auto-enter calculation that imposes our preferred formatting upon phone numbers -- it looks like this:


Let (

[@Phone = Self;

@Numbers = Filter(@Phone; "+1234567890")];

Left(@Numbers; 3) & "." &

Middle(@Numbers; 4; 3) & "." &

Right(@Numbers; 4)



It works great for U.S. phone numbers; international numbers...not so. The presence of more than 10 digits makes it go haywire, and my brain gets fried when I try to think of how I could accommodate for this occurrence.


If an international number comes to me like this:



I want it to auto-format to



But adding extra numbers to the Right function then louses up domestic numbers. I will be grateful for any thoughts...