I have scrapped data from website which has 6 columns including column name Last price with values in decimal. When I tried to select query to filter value which is less than 1000, it is not working and returns all values
newDT = ExtractDataTable.Select(“[Last Price] < ‘1000’”).CopyToDataTable
when I add newDT to excel, I see all values including ones greater than 1000… website ref: Gap Up BSE, Gap Up Stock, Stock Gap Up, Gap Up Share, Bar Chart Patterns.
thanks in advance