Advanced Filter

if (colFilter.Contains(" IN ") == true )
{
var temp1 = colFilter.Trim().Split(new string[] { "IN" }, StringSplitOptions.None);
colName = GetStringBetweenChars(temp1[0], '[', ']');
var filterValsList = temp1[1].Split(',');
newColFilter += string.Format("({0} != null && (", colName);
string orOperator = "";
foreach (var filterVal in filterValsList)
{
double tempNum = 0;
if (Double.TryParse(filterVal, out tempNum))
newColFilter += string.Format("{0} {1} = {2}", orOperator, colName, filterVal.Trim());
else
newColFilter += string.Format("{0} {1}.Contains({2})", orOperator, colName, filterVal.Trim());
orOperator = " OR ";
}
newColFilter += "))";
}