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
Any ideas here please?
BTW, the ticket number is not a consistent length!