Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

subfield with different separators

Hi,

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.

1 Solution

Accepted Solutions

Re: subfield with different separators

Hi Ed, maybe this can help you:

subfield(subfield(subfield(URL, '/', 1), '?', 1), '#', 1)

2 Replies

Re: subfield with different separators

Hi Ed, maybe this can help you:

subfield(subfield(subfield(URL, '/', 1), '?', 1), '#', 1)

Not applicable

Re: subfield with different separators

Wonderful! Thank you Ruben for your swift and correct solution - saving me much time and energy. Kind regards, Ed.

Community Browser