Row filtering by odd/even numbers

Hi everyone,

I want to split/filter my table on the column called ‘new col’ based on if the number is even or odd. I think the regular expression might help me to do this, but I am not sure how to get started? any advice would be most appreciated. Seems like a simple task, but I am struggling!

Hello @cm13hf,

you can use Math Formula with mod() function and then use filter or split based on new column. If you want to use regex then see here: help with line edits. transfer the next row into a different column



Hello @cm13hf,

or you can use Math Formula with following syntax which returns only the results 0 or 0.5.



1 Like

Thank you very much for your quick reply! Really appreciate the help

1 Like

Brilliant, thank you very much. Thanks for responding so quickly!

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.