I have a column of URLs and I'd like to extract the strings after the last "/". For example, *www.site.com/string1/string2/string3/**string4***--how would I extract just string4? All the URLs are different lengths so I'm looking for something dynamic. Thank you!

CodePudding user response：

SELECT 
    column1 as url,
    regexp_substr(url, '/([^/] )$',1,1,'e',1) as tail
from values
    ('https://stackoverflow.com/questions/72397941/finding-substring-based-on-pattern'),
    ('9/30/21 22:30'),
    ('http://www.example.com/string1/string2/string3/**string4***--how')
;

gives:

haha I left a date string from a prior question in there, but it shows the tail match working..