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: http://www.moneycontrol.com/technicals/gapup/bse/index.html.
thanks in advance