Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a question trimming a URL string in qlik.
For example,
I want to remove 'https://www.' and the last '/' in the string. Also, if they have '/#' in the string then remove everything after the '/#'. Any suggestions?
Thanks!
Hi Joerg,
It's not clear to me what you need based on the truncated URL's you shared. Can you share the full URL's and expected outputs the same way the originator of this thread did?
Regards,
JohnInSD
(aka johncaqc)
Hello Again,
I believe I got there myself:
=IF(SubStringCount(UrlString,'?')>0,LEFT(SubField(UrlString,'?',1),Len(UrlString)),IF(SubStringCount([GA_ZI_Sessions.DataFromQueryURI_dim_pagePath],'&')>0,LEFT(SubField(UrlString,'&',1),Len(UrlString)),UrlString))
Best Regards
Joerg