Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Extracting Date From URL String

Topic Labels: dates Formulas URLs
463 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi All

I'm currently scraping data from a few event listing websites into Airtable to create a database of events for the LGBTQ community.

On a few of the websites, I can't extract the full event date from the listings, this only appears in the URL.

An example of the URL is:

https://www.admiral-duncan.co.uk/soho/02-01-2023/karaoke-showdown-with-candy-heals

Is there any easy way to do this?

The other issue is that each site link has a different URL length, but the way they show the date is the same each time:

https://www.the2brewers.com/london/08-12-2022/panto

Any suggestions?

Thanks

2 Replies 2

Hi there,

I'm no formula expert, but this should do the trick, as long as the dates are indeed formatted the same way:

REGEX_EXTRACT({URLField},"\d\d-\d\d-\d\d\d\d") 

You could even go a step further and change the formatting of the date to read "February 01, 2023" for example:

DATETIME_FORMAT(REGEX_EXTRACT(Notes,"\d\d-\d\d-\d\d\d\d"),'MMMM DD, YYYY')