Help

Need phone number formula

Topic Labels: Formulas
471 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)