url string
1 Topic
Stripping out the query string in a URL returning blank
Hello, I am trying to strip out everything including and after the ? from my url [page_location] to report on page usage, I am also stripping out my own website address to shorten the result. eg in the below random website example url https://ortc.com.au/products/logo-quarter-zip-charcoal?variant=41124690722934 all that would be left is /products/logo-quarter-zip-charcoal My query, which is a result partly of these forums and our chatgpt friend, is below but keeps returning blanks for every result. If anyone has any ideas I would be extremely grateful! Page Path = VAR Destringed_Page_Loc = IF( CONTAINSSTRING(Query1[page_location], "?"), LEFT(Query1[page_location], SEARCH("?", Query1[page_location]) - 1), Query1[page_location] ) RETURN SUBSTITUTE(Destringed_Page_Loc, "https://www.myurl.com.au", "")Solved811Views2likes1Comment