Extract part of URL string in a table report?

[ihayes]

I have a URL string in a Looker table report where I want to extract part of the URL to display as a separate column. The URL string is not a fixed format, so I can’t use a known start and finish position

I can see a “split” function but there does not appear to be a related function to retrieve a list item by position.

In my report I have had to create multiple table calculations to represent different parsing steps. Is there an easier way of doing this?