Filter data table and convert string to number

I scrap a datatable on a website and store it in a datatable. Then I want to filter all items above a certain threshold (e.g. 8). By scrapping the data out of my chrome browser and using “filter data table”, each cell is interpreted as a string, so I cannot filter (or even sort) them nicely.

Does anybody knows a nice way to solve it without making this step more complicated by using a loop or something…?

thanks in advance

Hi @Sidame00,

Use the below expression in assign statement and store the output in another datatable

VarDatatble.Select(“ColumnName>‘8’").CopyToDataTable

7 Likes

thanks alot, it worked well.

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