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 (203040) Can any help?

Amit Gupta · 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 (203040) to execute query. The above expression is stored in a string variable

Vivek Kumar · Answer

what do you want ? Can you elaborate your question?