Hi everyone,
I have some data in one column that is in the following form:
ABC00001
ABC02485
ABC03713
ABC02949
ABC03235
I am trying to delete the rows that have numbers whose last 2 digits are less than or equal to 20. So, in the above example, row 1 and row 3 would be deleted. Can anyone help me with this?
I figured the best way is to first split the letters from the digits, then do the “<=20” test, then remove those rows, then put the letters and numbers back together. I’m still quite new to knime, so if anyone has a better way or can help me do this, it would be much appreciated!