Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
rubenmarin

Hi Ed, maybe this can help you:

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

View solution in original post

2 Replies
rubenmarin

Hi Ed, maybe this can help you:

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

Not applicable
Author

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