Extracting part of a string based on a pattern

[elsenorjose]

Ok so I'm sure I've seen the solution to this countless times but I can't remember how to do it.

I have a field that stores URL strings. They are all a little different but share a common format. Couple of example:

/D/705/19239/v0001/reflector:62123
/D/705/19239/v0001/reflector:62125
/D/705/19239/v0001/reflector:62127

What I want to do is display and group on just the last part of the string after the last '/'. So what I want is:

reflector:62123
reflector:62125
reflector:62127

How would I extract this part of the URL? It's always the last portion of any URL so I would imagine it would be a combination of Right{tbl.fieldname} and InStr but I can't figure it out.

Thanks.

 

[elsenorjose]

Sorry, just realized I was in the wrong forum! Posting in Crystal Reports forum.