- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 10, 2024 08:23 AM
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!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 15, 2024 10:49 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 15, 2024 10:49 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 17, 2024 06:15 AM
This worked perfectly! Thanks so much for your help with this!
