Unfortunately there's no way to extract the URL using a formula field. You could use a script to extract it, but it might be tricky if you have multiple URLs in the same field.
Unfortunately there's no way to extract the URL using a formula field. You could use a script to extract it, but it might be tricky if you have multiple URLs in the same field.
That's a bummer, but makes sense!
That's a bummer, but makes sense!
@Paul_Matsushima Hi! I played sometime with regex in a formula field and come so far with the following solution:
CONCATENATE(
REGEX_EXTRACT({Simple text},"(https?:\\/\\/)"),
REGEX_EXTRACT({Simple text},"(?:https?:\\/\\/)+([^\\s?]+)")
)It can extract only the first URL in text. Hope this helps.
@Paul_Matsushima Hi! I played sometime with regex in a formula field and come so far with the following solution:
CONCATENATE(
REGEX_EXTRACT({Simple text},"(https?:\\/\\/)"),
REGEX_EXTRACT({Simple text},"(?:https?:\\/\\/)+([^\\s?]+)")
)It can extract only the first URL in text. Hope this helps.
@Andrey_Kovalev That would work if the URL were exposed from the long text field. However, when using the rich text option to turn text into a clickable link, other formula fields that pull the resulting text only get the text, not the URL.
@Andrey_Kovalev That would work if the URL were exposed from the long text field. However, when using the rich text option to turn text into a clickable link, other formula fields that pull the resulting text only get the text, not the URL.
@Justin_Barrett Ahh, got you! I should have read the request more carefully.
