Creating a column with data from URLs

[kurtcollins]

I'm pulling URL data from Google Analytics to view a list of least viewed pages. Since the data is so vast, even for a 90 day timeframe, I want to create a slicer to limit the data by category. I can pick the category out of the URL, but I'm having trouble setting up a good calculation. Here's an example of the URL list.

website.com/category

website.com/category.html

website.com/category/sub-page.html

And it goes on and on like that with category text varying in length and the delimiters that surround it. Setting a start and end delimiter doesn't seem like an option because the delimiters vary and just doing a range of text doesn't work either, since the text varies in lenghth. Any suggestions or corrections on my assumptions?

[v-chuncz-msft · Accepted solution]

@kurtcollins ,

You may use code below to add a custom column.

Text.BetweenDelimiters(Text.Replace([Column1], ".html", "/"), "/", "/")

[kurtcollins]

Thanks! That worked.