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.
Cheers
Sam
thanks Sam!