Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Need phone number formula

Topic Labels: Formulas
977 2
cancel
Showing results for 
Search instead for 
Did you mean: 
madavilla
4 - Data Explorer
4 - Data Explorer

Hi, I need to have three fields that have parts of a phone number in each field. 

For example, if the phone number is (123)456-7890, I need three fields that return:

field1: 123

field2: 456

field3: 7890

Can anyone help me with a formula that would accomplish this? Thank you!

2 Replies 2
Sho
11 - Venus
11 - Venus

 

Hi @madavilla ,

In Regex will look like this

REGEX_EXTRACT({phone number},"\\((\\d+)\\)")
REGEX_EXTRACT({phone number},"(\\d{3})-")
REGEX_EXTRACT({phone number},"-(\\d{4})")

 

ScottWorld
18 - Pluto
18 - Pluto

@madavilla 

It would be very easy and you wouldn’t even need REGEX. Just something like these:

MID({Phone NumberField}, 2, 3)

MID({Phone NumberField}, 6, 3)

MID({Phone NumberField}, 10, 4)