How do I parse a url?

[alphacp]

Hi, I have a field that is simply a url. The url is a link to a ticket so something like “https:///mysystem.com/tickets/1234567” and I would like to be able to refer to the ticket number itself as part of a virtual column.

I was thinking that I could use Split() to parse the url in to a list and then use Index() to somehow reference the last item in the list but this has not worked so far. I tested with just trying to return the first part (i.e., “https:”) using this expression

INDEX(SPLIT([Ticket],"/"),1)

Any ideas here please?

BTW, the ticket number is not a consistent length!