Help

Extract URL from text field in Airtable

Solved
Jump to Solution
3503 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}, '\\((.*?)\\)'))