How to filter complete number column in other excel

[satish.rathi59 (Satish Rathi)]

I have use read range and then filter number start with 678 but not getting output

[supermanPunch (Arpan)]

Hi @satish.rathi59 ,

Could you make the value as a String and check if it works ?

"678"

[satish.rathi59 (Satish Rathi)]

I have already check this but not working

[supermanPunch (Arpan)]

@satish.rathi59 ,

In that case, could you check in the Debug Panel, how the value is represented in the Datatable ?

[Anil_G (Anil Gorthi)]

@satish.rathi59

Please check the column type and jow thw value looks in locals panel…

Apart from that you can use linq

dt = Dt.AsEnumerable.Where(function(x) x("Number").ToString.StartsWith("678")).CopyToDataTable

Hope this helps

Cheers