Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
thimma_paul
Contributor III
Contributor III

Hi all,i had a URL as field, in the url there is ProjectID=" some value". so here i need to find project id values for all rows, that i need to display in list box?

Hi all,i had a URL as field, in the url there is ProjectID=" some value". so here i need to find project id values for all rows, that i need to display in list box?

1 Solution

Accepted Solutions
Not applicable

Hi Thimma,

should be able to use textbetween for this

Textbetween([URl Field],'Projectid=','&') As Project

hope that helps

Joe

View solution in original post

3 Replies
thimma_paul
Contributor III
Contributor III
Author

Example : /hppcf/dologin.do?lang=en&cc=GB&Projectid=sp4ts&applandingpage=https%3A%2F%2Fh20565.www2.hp.com%2Fportal%2Fsite%2Fhpsc%2Fpublic%2F

in this URL Projectid=sp4ts,, so now i need to find in all rows, which contains projectid's. i hope u understood my qn

Not applicable

Hi Thimma,

should be able to use textbetween for this

Textbetween([URl Field],'Projectid=','&') As Project

hope that helps

Joe

thimma_paul
Contributor III
Contributor III
Author

Thank you so much Joe