Extract a number from URL

[Daniel_Smith]

I am trying to extract an ID number from a URL field. The number is at the end of the URL.

I have tried MID, RIGHT & LEFT but no luck.

The formula will need to:

• get the number only

• Ignore other numbers in the URL

• Get the number right of the last ‘-’

• Ignore a ‘/’ if there is one at the end

Example data: https://airtable.com/shrM2cPJoq05OMoom

Example URLs:

• ‘https://www.eventbrite.com.au/e/long-name-of-workshop-here-could-be-very-long-48271930495|4827193049...’
• ‘https://www.eventbrite.com.au/e/shorter-name-859045958274|859045958274’
• ‘https://www.eventbrite.com.au/e/medium-length-name-95827485904/|95827485904/’