Filter numerics in Datatable from Excel

Help Studio
, ,
1

Hi,

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.

image

2

@Ayodeji_Osikoya

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
4

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