Hi Friends !!!
I just want to know the regular expression which should return only "EMPNO=","DEPTNO=","JOB=" from the following query with set of placeholder values,
"select * from EMP where EMPNO=&eno and DEPTNO=&dno and JOB=&job".
The query may be dynamic,like it may contain even a single placeholder value like,
"select * from EMP where EMPNO=&eno"
I just need a general regular expression that should return the "EMPNO=","DEPTNO=","JOB=" variables from the query. [key point here is : take the variable which is residing before "&" and stop obtaining it when a space comes in. like "where EMPNO=&eno" before "&" it contains EMPNO=]
Could anyone please help me out in this ?
Thanks,
Warm Regards,
Saravanan