Can't seem to search for 0.00
Can't seem to search for 0.00
kmo12345
Posts: 1Questions: 1Answers: 0
http://live.datatables.net/fuqaqeci/1/
I have a table with many prices such as 100.00 120.00 20.00 and 0.00
I would like to search for rows with a price of 0.00 but a search for 0.00 always returns all rows. I understand that 100.00 includes 0.00 so I tried "0.00" and that doesn't seem to work either?
Lastly, I tried turning regex mode on but then using ^0 doesn't find any rows at all...
Any idea why this is happening?
This discussion has been closed.
Answers
The easiest way would be to use
column().search()with a regex search. Using a global search with the^won't work as it is not applied to each column what searching. See this example:http://live.datatables.net/fuqaqeci/2/edit
Kevin