remove ∞

A double column contains ∞. Any recommendations on how to remove the row containing it? Row filter ranges, pattern match do not seem to work.. thanks in advance.

You can use a Java Snippet row filter with the following match:


return $Infinity$ == Double.POSITIVE_INFINITY ? false : true;


Where the column containing the infinity symbol is called Infinity.


You may also be interested in Double.NEGATIVE_INFINITY.





thanks Sam!