Filter table with doule value

[ppr (Peter Preuss)]

Feel free on trying the following LINQ as an alternate

Assign Activity
dt2 =

(From d in dt1.AsEnumerable
let c1 = d("Descr.......").toString.Trim.ToUpper
Let c2 = d("Novo saldo....").toString.Trim
Where c1.Contains("CAR_DUPL") AND CDbl(c2) >= 500
Select r=d).CopyToDataTable

just complete the column name
ensure that the data is within the expected formats and values

Handling empty results:

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.AsE…