Hello All,
I am running the jdbc request sampler to execute a query "select userName,
password from User limit 10" against a mysql database. The result that
comes back is:
userName password
user1 password1
user2 password2
user3 password3
user4 password4
user5 password5
user6 password6
user7 password7
user8 password8
user9 password9
user10 password10
Now I would like to create a regular expression that extracts all the users
and passwords and use the results in a foreach type controller. Problem is
I need to not match "userName password".
I have tried the regular expression
"(?!userName)([a-zA-Z0-9]+)\s+([a-zA-Z0-9]+)" . This does not match
"userName" but does match "serName"!
So the problem is solved either:
1. not having the jdbc request sampler return the heading row ("userName
password"), or
2. fix the regular expression
Any help would be appreciated.
Thanks,
Angelo.
