Regex Query to get string value
- by Alex
Hi all, I am looking for a regex query that would allow me to retrieve a value from a string
here are examples of my string:
home.aspx?StudyID=0020101&aa=72
randompage.aspx?studyid=3023603&aa=40
myconfig.aspx?studyid=0021600&aa=40
I need to get the numerical value of the 'studyid' variable, please note that the name of the page will change so simply doing the substring and counting char spaces didn't work
I unfortunately cannot use request.querystring method as this string is stored in the database and a select statement will be used for running this regex query
Thanks