Filter columns based on certain header names

Hello everyone,

I am trying to get a column filter based on a regular expression.

There are multiple columns with different names.

They are always in this order: col1, col2, col finished, col4, col failed, col5, col1_2, col2_2, col finished_2, col4_2, col failed_2, col5_2, col1_3, …

I want to only include the columns with the words “finished” or “failed” in the column headers but they also should stay in the same order like this: col finished, col failed, col finished_2, col failed_2, col finished_3, …

On a regular expression testing site the regex /\bfinished|\bfailed/g works, but not in KNIME…

Anyone have an idea how to solve this?

I found a solution:

.*finished*|.*failed*.*

3 Likes

Glad you were able to get it working! :+1:

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