Filter numerics in Datatable from Excel


Im trying to filter from a all numerics and “EXW” from a datatable.

Is there a way this can be done? i would like some help.



Try below expression.

      Filter3 = Filter2.AsEnumerable().Where(Function(row) row("Incoterms").ToString.Contains("EXW") OR IsNumeric(row("Incoterms").ToString)).CopyToDataTable

I guess you need to use OR condition here instead of And.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.