Extracting Date From URL String

Topic Labels: dates Formulas URLs
1411 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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:

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:

Any suggestions?


2 Replies 2
7 - App Architect
7 - App Architect

Hi there,

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

7 - App Architect
7 - App Architect

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')