find same words in string expression

Question

I have a expression like as follows,

 

(Age = 20 and Age = 30 and Age = 40)

 

I want to convert the above expression as

 

Age IN (20,30,40)

 

Can any help? 

Answer 1

Use Replace function to generate your desired output

 

string age ="(Age = 20 and Age = 30 and Age = 40)";
var value = "Age in" + age.Replace("Age","").Replace("=","").Trim().Replace("and",",").Trim();

 

 Isnt simple?

Answer 2

Are you using c#? Can you wite your sample code? 

Answer 3

Actually the string expression (Age = 20 and Age = 30 and Age = 40) needs to be converted to 

Age IN (20,30,40) to execute query. The above expression is stored in a string variable 

Answer 4

 what do you want ? Can you elaborate your question?