Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help! Finding last occurrence of specific string

Topic Labels: Formulas
700 1
cancel
Showing results for 
Search instead for 
Did you mean: 
nataliagruber
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, "[^/]+$")

👍