Can i use regex in Qlik Sense?

[Anonymous]

Hi,

i want to use regex in Qlik Sense for a selection field for example. One field shows URL´s and i want to cut http://www.domain.com/ and show only the rest from the url.

Is that possible?

regards,

René

[Gysbert_Wassenaar · Accepted solution]

Not regex, but it shouldn't be too hard to cut off the first part: mid(MyUrlHere, index(MyUrlHere, '/', 3)+1) as RestOfUrl

And if you want the last part page1.html?p1=123&p2=abc of an url like http://www.domain.com/news/20160421/a/page1.html?p1=123&p2=abc then you can use:

=mid(MyUrlHere, index(MyUrlHere, '/', -1)+1)

[Anonymous]

Great, thanks a lot!

regards,

rené