Help! Finding last occurrence of specific string

Topic Labels: Formulas
194 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have a base with records that consist of the URLs of several images inside my site's midia folder. They look something like:

Etc, fake examples. 

I would like to extract just the names of the files inside each folder, like:

  • banner1.png
  • banner2.png
  • file.html
  • name.pdf

I figured it might be possible if I could FIND the last '/' on each string and extract whatever comes after it, but I'm not managing. Anyone knows if that's possible? 

1 Reply 1

Hello @nataliagruber 
Use this simple RegExp function which always gives you perfect results.

REGEX_EXTRACT(url, "[^/]+$")