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?

Amit Gupta · Accepted Answer

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?

Vivek Kumar · Answer

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

Ajay Mavatkar · Answer

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

Vivek Kumar · Answer

what do you want ? Can you elaborate your question?