Removing rows that have a column that starts with a alpha vs a number

KNIME Analytics Platform
1

I have a huge list of items. I need to split them into two tables. Those that begin with a number and those that begin with alpha. I can’t seem to get any of the row splitter nodes to do what I want. Any suggestions?

2

You may solve your task with pare of Rule -based Row Filters containing logic
$column3$ LIKE “0*” => TRUE
$column3$ LIKE “1*” => TRUE
$column3$ LIKE “2*” => TRUE
…
$column3$ LIKE “9*” => TRUE
One with include another exclude option.
Also, Rexex $column3$ MATCHES “^\d{1}.*” => TRUE
will work.

2 Likes
3

@izaychik63, Thanks, I was over thinking it!