Regex Query to get string value

Question

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

What programming language or program are you using?

badp
– badp

2010-04-22 16:00:16 +00:00
Commented Apr 22, 2010 at 16:00 — badp
– badp, Commented Apr 22, 2010 at 16:00

SilentGhost · Accepted Answer · 2010-04-22 15:43:04Z

2

/studyid=(\d{7})/i

answered Apr 22, 2010 at 15:43

SilentGhost

322k67 gold badges312 silver badges294 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

george9170 Over a year ago

I would recommend not using the {7} quantifier. I wouldn't recommend this because he hasn't stated how long a studyID could be. If it is longer then 7 chars then your regex blows up.

SilentGhost Over a year ago

@george: if the value is any different than that, then OP needs to provide relevant examples.

Alex Over a year ago

Yes generally it is 7 chars, so should be ok Thanks

user271586 · Accepted Answer · 2010-04-22 15:43:20Z

1

Use can use parenthesis to capture values in regex.

Therefore, you can match the string to studyid=(\d+) and get the value using $1.

answered Apr 22, 2010 at 15:43

user271586

Comments

tloflin · Accepted Answer · 2010-04-22 15:42:49Z

0

/studyid=([^&]*)&/i

The first group will contain the variable.

answered Apr 22, 2010 at 15:42

tloflin

4,0701 gold badge28 silver badges35 bronze badges

Collectives™ on Stack Overflow

Regex Query to get string value

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related