I have statement data in datatable using screen scraping all column in string data type, I want to get max debit entry from debit column with remaining balance from bal. Column. I write extracted datatable in Excel shows number stored as text. Due to this I’m not able to find max value from debit …

Get max value from extracted datatable

balupad14 (Balamurugan (BalaReva)) January 3, 2023, 9:42am 7

Can you try this one.

simple solution
maxVal= dt.AsEnumerable.Max(Function (y) CDbl(y(“debit”).toString.Trim))

Detailed solution

Regards
Balamurugan.S

1 Like