Search In Excel Data Table using linq

Help Studio
, ,
6

@dutta.marina

Try this

ExtractDataTable.AsEnumerable.Where(Function(x) System.Text.RegularExpressions.Regex.IsMatch(x("List price (Quantity)").ToString,"\d+.\d{2}\d*(?<=[1-9])|\d+.\d{2}") AndAlso x("Charges”).ToString=sku_name AndAlso x("List price (Quantity)").ToString <> sku_listprice).Count >0

Cheers