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
Extract URL from text field in Airtable
+2Best answer by TheTimeSavingCo
You can use regex for this. Try a formula field with the following:
REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')
+31You can use regex for this. Try a formula field with the following:
REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')
+2You can use regex for this. Try a formula field with the following:
REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')
Yeah it works,
Thank you
+2You can use regex for this. Try a formula field with the following:
REGEX_EXTRACT([FIELD NAME], '\\((.*?)\\)')
is there a way to remove the error message from the empty field
+3is there a way to remove the error message from the empty field
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}, '\\((.*?)\\)'))
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.