row filter

aurelienchauvin · September 24, 2024, 8:59pm

hi ,
Is it no longer possible to filter using a regular expression on numbers with the new version?

ty

yogesh_nawale · September 25, 2024, 4:57am

Regular expressions in KNIME are primarily designed for string data types. When dealing with numerical columns, you may need to convert these numbers to strings before applying a regex filter.

Regards,
Yogesh

wiswedel · September 25, 2024, 1:51pm

The “new” Row Filter node, which was added in 5.3.0, has received some minor updates in 5.3.2, including the ability to apply filtering via wildcard/regex also on integer types (int, long). See screenshot below (“age” is an integer column here).

yogesh_nawale · September 26, 2024, 5:33am

Thanks, @wiswede. I was using KNIME 5.3.0, so I didn’t see the option for regex and wildcard matching, which is available in KNIME 5.3.2. Thanks again for pointing it out.