Help

Extract a number from URL

Topic Labels: Formulas
846 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Smith
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

0 Replies 0