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

[Brooke_Lutz]

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:

• https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A
  
  

• Sample format 2: includes ?ABC=1 at the end 
  • https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A?ABC=1 

• Sample format 3: includes 2 URLs only separated by a space
  • https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A ABC: https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A?ABC=1

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

[j-hugg-ins · Accepted solution]

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.

[Brooke_Lutz]

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