Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Extract URL from text field in Airtable

Solved
Jump to Solution
4148 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Sched_kode
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

You can use regex for this.  Try a formula field with the following:

 

REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')

 

Screenshot 2023-03-04 at 11.26.12 AM.png

See Solution in Thread

4 Replies 4
TheTimeSavingCo
18 - Pluto
18 - Pluto

You can use regex for this.  Try a formula field with the following:

 

REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')

 

Screenshot 2023-03-04 at 11.26.12 AM.png

Yeah it works, 

Thank you

is there a way to remove the error message from the empty fielderror.PNG

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}, '\\((.*?)\\)'))