Discussion Board for collaboration on QlikView Scripting.
I would like to create a subfield from url strings, mostly seperated by '/' but also by two others namely:
'?' and '#'.
My question is how to grasp all three in the formula.
subfield(URL, '/', 1) is standard, but how do I add the other two to the formula?
I need it to function in the load script.
Thanks in advance, kind regards, Ed.
Go to Solution.
Hi Ed, maybe this can help you:
subfield(subfield(subfield(URL, '/', 1), '?', 1), '#', 1)
Wonderful! Thank you Ruben for your swift and correct solution - saving me much time and energy. Kind regards, Ed.