Filter Column on Mulitple Decimal Points
Filter Column on Mulitple Decimal Points
![pendas](https://secure.gravatar.com/avatar/5a8b43eaa85981f5b33c78d53821533e/?default=https%3A%2F%2Fvanillicon.com%2F5a8b43eaa85981f5b33c78d53821533e_200.png&rating=g&size=120)
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