Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.