Filter Column on Mulitple Decimal Points
Filter Column on Mulitple Decimal Points
I am using the range filter to enable filtering on decimal points. The code I have will only filter on the first instance of the decimal point and nothing after it. For example i am able to use my code to filter on the first number after the decimal in 470.6.00, but not more than that. So if I search for 470.6.1 as the min value 470.6.00 appears, even though it is under the min. Any thoughts on how I can get the code below to filter after the next decimals?
Sample of what I have here:
https://jsfiddle.net/t13zLLLc/28/
Answers
You are using
parseFloat()
which returns a flowing point number (one decimal). Everything after is dropped. I would look at using the string split() method to split the strings at the periods. Then do the range comparisons. It would take a bit of code to accomplish.Kevin