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