# Formatt phone number
**URL:** https://community.glideapps.com/t/formatt-phone-number/63282
**Category:** Ask for Help
**Created:** [June 29, 2023, 12:15am UTC](https://community.glideapps.com/t/formatt-phone-number/63282 "2023-06-29T00:15:12Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@John\_Romano](https://community.glideapps.com/u/John_Romano)
#### Post date: [June 29, 2023, 12:15am UTC](https://community.glideapps.com/t/formatt-phone-number/63282/1 "2023-06-29T00:15:12Z")
I want to be able to take a phone number input and strip it down to just raw numbers and then reformatt it. That is what I am thinking the flow should be after we collect.
A one two punch with formula columns. For instance…
If a sales rep opens a form and enters any number like this
{{— 15045551212, or, 1(504)555-1212, or, (504) 555-1212, or, 504-555-1212, or, 1-504-555-1212, ect…—}}
take any of those and…
1st:Strip a leading one away from it if it is present & remove any spaces or special characters out and,
2nd: reformatt to this (504) 555-1212 every time.
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [June 29, 2023, 12:23am UTC](https://community.glideapps.com/t/formatt-phone-number/63282/2 "2023-06-29T00:23:53Z")
Here’s a gem 💎 from Darren
> [@I need help with regular expressions and formatting](https://community.glideapps.com/t/i-need-help-with-regular-expressions-and-formatting/62863/3):
>
> I started having a look at this yesterday, and ended up going down a bit of a rabbit hole, so I put it aside. Had another look just now and it occurred to me that all you really need to do is strip out all the non-digits and then return the last 9 characters of whatever is remaining. So with that in mind, here is a bit of rough and ready JavaScript that does that. I’m sure it could be improved. const parts = p1.split(''); let digits = []; while (parts.length \> 0) { let bit = parts.shift(); …
---
### Author:  [@John\_Romano](https://community.glideapps.com/u/John_Romano)
#### Post date: [June 29, 2023, 1:44am UTC](https://community.glideapps.com/t/formatt-phone-number/63282/3 "2023-06-29T01:44:33Z")
Thank you! How do I implement this? I am a versatile NO CODE builder and I have zero experience with a column type like this…I just need a little head start on what column and how to input the code below and start to test it out…but it seems pretty incredible…
const parts = p1.split(‘’);
let digits = ;
while (parts.length \> 0) {
let bit = parts.shift();
if (bit.match(/\d/)) {
digits.push(bit);
}
}
return digits.slice(-9).join(‘’);
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [June 29, 2023, 2:17am UTC](https://community.glideapps.com/t/formatt-phone-number/63282/4 "2023-06-29T02:17:18Z")
Hola John,
Try with this code…
```auto
var phonePattern = /\d+/g;
let phoneText= p1.match(phonePattern).join('');
let len=phoneText.length;
let string4=phoneText.slice(len-4,len);
let string3=phoneText.slice(len-7,len-4);
let string2=phoneText.slice(len-10,len-7);
let string1=phoneText.slice(0,len-10);
return string1+ " (" + string2+ ") " +string3+ "-" + string4
```
If you want to remove the International Calling Codes, remove everything associated to _string1_ variable in my code
Saludos!
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [June 29, 2023, 3:12am UTC](https://community.glideapps.com/t/formatt-phone-number/63282/5 "2023-06-29T03:12:09Z")
> [@John\_Romano](#):
>
> I am a versatile NO CODE builder and I have zero experience with a column type like this
A little bit of code won’t hurt 😉. Use the Java script column
---
### Author:  [@John\_Romano](https://community.glideapps.com/u/John_Romano)
#### Post date: [June 29, 2023, 1:16pm UTC](https://community.glideapps.com/t/formatt-phone-number/63282/6 "2023-06-29T13:16:25Z")
that worked besides removing a 1 if found in the beginning…can you give me that?
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [June 29, 2023, 5:41pm UTC](https://community.glideapps.com/t/formatt-phone-number/63282/7 "2023-06-29T17:41:49Z")
Sure!
use this if you don’t want to use International Calling Codes:
```auto
var phonePattern = /\d+/g;
let phoneText= p1.match(phonePattern).join('');
let len=phoneText.length;
let string4=phoneText.slice(len-4,len);
let string3=phoneText.slice(len-7,len-4);
let string2=phoneText.slice(len-10,len-7);
return "(" + string2+ ") " +string3+ "-" + string4
```
Chao!
---
### Author:  [@John\_Romano](https://community.glideapps.com/u/John_Romano)
#### Post date: [June 30, 2023, 12:24pm UTC](https://community.glideapps.com/t/formatt-phone-number/63282/8 "2023-06-30T12:24:14Z")
Thanks man that worked perfect…could I ask you for one more favor, and if we ever meet the first whopper from BK is on me… Can you give me a formula that removes a leading 1 if it is present and all special characters and spaces also. I need this for a webhook that i send these to that the api on the other end of the webhook will not accept nothing but that. 1 (504) 555-1212 to 5045551212
Much obliged sir :::—)))
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 30, 2023, 12:41pm UTC](https://community.glideapps.com/t/formatt-phone-number/63282/9 "2023-06-30T12:41:41Z")
You can just change the Return and remove the special characters.
return string2 + string3 + string4
---
### Author:  [@John\_Romano](https://community.glideapps.com/u/John_Romano)
#### Post date: [June 30, 2023, 1:29pm UTC](https://community.glideapps.com/t/formatt-phone-number/63282/10 "2023-06-30T13:29:59Z")
THANK YOU VERY MUCH JEFF! I appreciate your help!
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [June 30, 2023, 3:05pm UTC](https://community.glideapps.com/t/formatt-phone-number/63282/11 "2023-06-30T15:05:35Z")
> [@John\_Romano](#):
>
> and if we ever meet the first whopper from BK is on me…
ok… but don’t forget the Pepsi or Coke 😉
Enjoy the code!
Feliz día…
---
### Author:  [@Info\_Appolon](https://community.glideapps.com/u/Info_Appolon)
#### Post date: [April 24, 2024, 10:28pm UTC](https://community.glideapps.com/t/formatt-phone-number/63282/12 "2024-04-24T22:28:33Z")
Am I doing something wrong or were there some changes in glide that affect the way to format it?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 24, 2024, 11:44pm UTC](https://community.glideapps.com/t/formatt-phone-number/63282/13 "2024-04-24T23:44:59Z")
Please try this.
```auto
p1 = p1.toString(); // convert p1 to a string
p1 = p1.replace(/\D+/g, ''); // remove all non-digit characters
if (p1.length !== 10) {
return('Invalid phone number');
} else {
return('(' + p1.substring(0, 3) + ') ' + p1.substring(3, 6) + '-' + p1.substring(6));
}
```
