Help

How to pull specific text out of a string that could have multiple formats

Topic Labels: Formulas
Solved
Jump to Solution
303 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brooke_Lutz
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a URL field that I need to grab specific text from (in bold). Does anyone know if there is a formula I could use to easily grab just the string in bold without pulling in additional data from the 3 possible formats?

Here are the multiple formats that the URL could be in:

Sample format 1:

Sincere thank you in advance for anyone who takes the time to look into this and provide any suggestions!

1 Solution

Accepted Solutions
j-hugg-ins
6 - Interface Innovator
6 - Interface Innovator

Hi Brooke. If the pattern of the UDID you are extracting is consistent you can use a regular expression in your formula field like this:

REGEX_EXTRACT(
    {url}, 
    "[A-F0-9]{8}-[A-F0-9]{4}-[A-F0-9]{4}-[A-F0-9]{4}-[A-F0-9]{12}"
)

 I tested it on all 3 of your examples and it works.

Screenshot 2024-06-16 064536.png

See Solution in Thread

2 Replies 2
j-hugg-ins
6 - Interface Innovator
6 - Interface Innovator

Hi Brooke. If the pattern of the UDID you are extracting is consistent you can use a regular expression in your formula field like this:

REGEX_EXTRACT(
    {url}, 
    "[A-F0-9]{8}-[A-F0-9]{4}-[A-F0-9]{4}-[A-F0-9]{4}-[A-F0-9]{12}"
)

 I tested it on all 3 of your examples and it works.

Screenshot 2024-06-16 064536.png

This worked perfectly! Thanks so much for your help with this!