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|48271930495’


• ‘https://www.eventbrite.com.au/e/shorter-name-859045958274|859045958274’


• ‘https://www.eventbrite.com.au/e/medium-length-name-95827485904/|95827485904/’