topic Re: subfield with different separators in QlikView https://community.qlik.com/t5/QlikView/subfield-with-different-separators/m-p/887756#M657440 <HTML><HEAD></HEAD><BODY><P>Hi Ed, maybe this can help you:</P><P>subfield(subfield(subfield(URL, '/', 1), '?', 1), '#', 1)</P></BODY></HTML> Tue, 19 May 2015 12:48:20 GMT rubenmarin 2015-05-19T12:48:20Z subfield with different separators https://community.qlik.com/t5/QlikView/subfield-with-different-separators/m-p/887755#M657439 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to create a subfield from url strings, mostly seperated by '/' but also by two others namely:</P><P></P><P>'?' and '#'.</P><P></P><P>My question is how to grasp all three in the formula.</P><P></P><P>subfield(URL, '/', 1) is standard, but how do I add the other two to the formula?</P><P></P><P>I need it to function in the load script.</P><P></P><P>Thanks in advance, kind regards, Ed.</P></BODY></HTML> Tue, 19 May 2015 12:42:35 GMT https://community.qlik.com/t5/QlikView/subfield-with-different-separators/m-p/887755#M657439 2015-05-19T12:42:35Z Re: subfield with different separators https://community.qlik.com/t5/QlikView/subfield-with-different-separators/m-p/887756#M657440 <HTML><HEAD></HEAD><BODY><P>Hi Ed, maybe this can help you:</P><P>subfield(subfield(subfield(URL, '/', 1), '?', 1), '#', 1)</P></BODY></HTML> Tue, 19 May 2015 12:48:20 GMT https://community.qlik.com/t5/QlikView/subfield-with-different-separators/m-p/887756#M657440 rubenmarin 2015-05-19T12:48:20Z Re: subfield with different separators https://community.qlik.com/t5/QlikView/subfield-with-different-separators/m-p/887757#M657441 <HTML><HEAD></HEAD><BODY><P>Wonderful! Thank you Ruben for your swift and correct solution - saving me much time and energy. Kind regards, Ed.</P></BODY></HTML> Tue, 19 May 2015 12:58:38 GMT https://community.qlik.com/t5/QlikView/subfield-with-different-separators/m-p/887757#M657441 2015-05-19T12:58:38Z