
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 03, 2023 07:08 PM
Hello community
Again faced with this, hope to get a simple workaround for this where I can get a formula that extracts URL from a text field.
Thanks
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 03, 2023 07:26 PM - edited ‎Mar 03, 2023 07:26 PM
You can use regex for this. Try a formula field with the following:
REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 03, 2023 07:26 PM - edited ‎Mar 03, 2023 07:26 PM
You can use regex for this. Try a formula field with the following:
REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 03, 2023 07:29 PM
Yeah it works,
Thank you

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 03, 2023 07:33 PM
is there a way to remove the error message from the empty field
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 16, 2023 12:21 PM
You could make the REGEX formula @TheTimeSavingCo provided above conditional on whether or not there is an attachment in your "Display attachment" field. Try this (adjusting the field names as necessary):
IF({Field name}, REGEX_EXTRACT({Field name}, '\\((.*?)\\)'))
