Extract URL from text field in Airtable

[Sched_kode]

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

[TheTimeSavingCo · Accepted solution]

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

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

[Sched_kode]

Yeah it works, 

Thank you

[Sched_kode]

is there a way to remove the error message from the empty field

[Nathan_Anderso1]

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