How to extract all url from a cell in Airtable
Status: Closed · Asked by Kenny on · 0 views
I have a cell value like this:
IMG_20220328_115251-01_result.jpg (https://dl.airtable.com/.attachments/f029910b1af2c017213a3a9c38ebecac/3781ccfe/IMG_20220328_115251-01_result.jpg), IMG_20220328_115311-01_result.jpg (https://dl.airtable.com/.attachments/cf9f1564d288e680dac8ec92660bff01/a402ee75/IMG_20220328_115311-01_result.jpg), 36531pwa305.jpg (https://dl.airtable.com/.attachments/2802f321b9b40b1b060befbc432ca8c0/06ce27db/WhatsAppImage2022-03-29at1_25_02PM_result.jpg), IMG_20220328_115259-01_result.jpg (https://dl.airtable.com/.attachments/a7f12ae94ca20f8c91a13ef0f06b6520/6a6ff202/IMG_20220328_115259-01_result.jpg)
I want to have only the urls inside the parentheses and separated by comma. How can i achieve this?
Fagun, i need those syntax hehe
Fagun, i need those syntax hehe
(http|ftp|https):\/\/([\w_-]+( :( :\.[\w_-]+)+))([\w.,@ ^=%&:\/~+#-]*[\w@ ^=%&\/~+#-])
(http|ftp|https):\/\/([\w_-]+(?:(?:\.[\w_-]+)+))([\w.,@?^=%&:\/~+#-]*[\w@?^=%&\/~+#-])
What is that sad face?
The forum automatically changes the some special characters into emojis. Check the screenshot for the actual special character.