Format phone numbers

[Snapper_Cridge]

Any on have eyes on formula to format a number? It’s a phone number column and I need all of the numbers to be in (###) ###-#### format. Any help is always appreciated.

[Pch]

Like this ? @Snapper_Cridge
(Assuming you enter the number in your table as one column )

[Ivo_Ezeta]

This is great, could you help advising in how to add the country code as well?
+1
for example.

Thanks!

[Pch]

Hi there @Ivo_Ezeta !

Sorry to get back at you so late !

Just in case you were still wondering about this, here is how I would add Country Code +1 to this .

I’ve also added another solution if other countries are needed too .

[Josh_Szwarga]

Looking to do the opposite and remove all parenthesis. Any guesses?

[Pch]

Depending how the phone number is originally entered in the table (I assume it was in a Text field here) but I’ve got this :
(The formula in Number might need some adjustments, depending on what your phone number actually looks like )

There might be other ways to get to that result too.

[Jean_Pierre_Traets]

Dear @Snapper_Cridge,

This post might also be of your interest

Click-to-call phone numbers

@Londya_Adam posted this question in the community: Coda doesn’t have a “Phone Number” column type, but you can create a click-to-call number by putting “tel:” before the phone number as the hyperlink for the phone number. This way, when you tap the number in the mobile app, it will launch your phone’s default phone dialer. See the formula in the Click-to-call column:

Credits to @Al_Chen_Coda

[Federico_Stefanato]

For the sake of simplicity, to “de-pattern” numbers there is an even easier solution:

[Formatted Number].RegexReplace("[^0-9]", "")

Which - literally - takes out every non number char.

As a hint, every time there is some string manipulation, take into consideration that RegexpMatch() and RegexpReplace() are very powerful and (usually) more efficient.
The drawback is to learn a bit of their syntax, but it worths doing it in the long term.

[Pch]

Thanks Frederico ! I’m gonna add this to the doc I shared .

I thought about using Regex but I didn’t had the time to look there .

(I’ve played around with RegexMatch() and RegexReplace() in the past, and I fully agree with you here about the efficiency, but it was some time ago and I didn’t got the chance, yet, to explore those formulas again )

[Josh_Szwarga]

@Federico_Stefanato @Pch Thank you! Very streamlined solution and works perfectly!