Parse url arguments

Question & Answer
1

I have a hacky way to do this but hoping to see this as a feature or maybe someone knows how to do it the other way.

Imagine you have a url as a value:

https://www.google.com/search?q=quicksight+is+cool&newwindow=1uact=5&oq=quicksight+is+cool

And you need to grab the value of “oq” from it, for example. Right now I am doing it by using a combination of “locate” and “substring” functions.

2

Another way I found, but only works if order of arguments in the url doesn’t change:

split(split({url}, "=", 3),"&",1)
3

Locate and Substring will work fine :slight_smile: