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 {{— 15045551…

Here’s a gem :gem: from Darren [image] I need help with regular expressions and formatting Ask for Help 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 …

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 digit…

Hola John, Try with this code… 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); …

[image] 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 :wink:. Use the Java script column

that worked besides removing a 1 if found in the beginning…can you give me that?

Sure! use this if you don’t want to use International Calling Codes: 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); …

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 th…

You can just change the Return and remove the special characters. return string2 + string3 + string4

THANK YOU VERY MUCH JEFF! I appreciate your help!

[image] John_Romano: and if we ever meet the first whopper from BK is on me… ok… but don’t forget the Pepsi or Coke :wink: Enjoy the code! Feliz día…

Formatt phone number

Ask for Help

Eric_Penn June 29, 2023, 12:23am 2

Here’s a gem from Darren

Topic		Replies	Views
I need help with regular expressions and formatting Ask for Help	7	651	June 19, 2023
Phone number too long, How to edit? (replace numbers with nothing) Ask for Help	5	151	March 28, 2024
Format a cellphone number with no special characters or spaces Ask for Help	11	2147	April 3, 2022
Phone number formatting Ask for Help	3	994	September 27, 2020
How to Format Number Ask for Help	6	124	May 5, 2024

Formatt phone number

Related topics