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

Question

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!

Best answer by j-hugg-ins

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.

j-hugg-ins · Accepted Answer

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.

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

Brooke_Lutz · Answer

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.

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

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded