Extract a number from URL

Topic Labels: Formulas
1071 0
Showing results for 
Search instead for 
Did you mean: 
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:

Example URLs:

0 Replies 0