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?

[thimma_paul]

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?

[thimma_paul]

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

[#3 · Accepted solution]

Hi Thimma,

should be able to use textbetween for this

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

hope that helps

Joe

[thimma_paul]

Thank you so much Joe