Filter dt by double precision numbers

Help Studio
, ,
6

Hi,

Alright.

If your datatable has just one column, the following will work

dt = dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow({Double.Parse(r(0).ToString)},False)).CopyToDataTable

If there are 2 or more columns, try Invoke Code activity with the following code.

dt = dt.AsEnumerable.Select(Function(r)
r(0) =  Double.Parse(r(0).ToString)
Return r
End Function).CopyToDataTable

Regards,

2 Likes