- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 04, 2023 02:59 PM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 04, 2023 05:34 PM
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})")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 04, 2023 06:27 PM - edited ‎Jul 04, 2023 06:28 PM
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)
