Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Extract a number from URL

Topic Labels: Formulas
653 0
Showing results for 
Search instead for 
Did you mean: 

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:

Example URLs:

0 Replies 0