Row filtering by odd/even numbers

[cm13hf]

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!

[ipazin]

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

Br,
Ivan

[morpheus]

Hello @cm13hf,

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

$$ROWINDEX$$/2-floor($$ROWINDEX$$/2)

BR

[cm13hf]

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

[cm13hf]

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