Extract a number from URL

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: