can you give me the regex

[simonmng]

I have a column with the name: “teststeps+verdict” in which are my teststeps and the according values (passed,error,failed) in this style: teststep1__FAILED, teststep2356728__NONE, teststep9312__PASSED, teststep8376169__PASSED, teststep43270329__FAILED, …

I want to get two new columns: teststeps passed and teststeps failed/error. Can you give me the code for both stringmanipulation nodes?
Thanks for your help

[ipazin]

Hello @simonmng,

you don’t need regex. You can use Cell Splitter with underscore (or two underscores) as delimiter.

Br,
Ivan

[gonhaddock]

Hello @simonmng
As @ipazin suggested Cell Splitter is a good option. But with comma as delimiter. Then unpivot resulting arrays, and validate FAILED/ERROR wildcards as a filter criteria.

Rule-based Row Filter can work.

BR

[simonmng]

But than i get many columns because everything is in one cell

[ipazin]

Hello @simonmng,

you didn’t mention that

Then you can use Cell Splitter with comma as delimiter, transpose your data and then use Cell Splitter as described in first post. That is under assumption I understood correctly how your data set looks like. In general it’s always a good idea to share part of your data. Dummy data works just fine

Br,
Ivan

[simonmng]

This is how it looks now

and this is the wanted result:

i don’t know why to transpose it. I think a regex is needed or am I wrong?

[gonhaddock]

Hello @simonmng
This is the deployment of the idea behind, as commented:

20241010_disaggregate_teststeps_CLASS_v3.knwf (17.3 KB)

no Regex at all

BR

[ipazin]

Hello @simonmng,

ok. Now it’s a bit clearer. If you want to use regex you can but using standard KNIME nodes is, I believe, good enough.

Here is regex for passed tests:
(teststep\d+)_passed

And here is regex for tests that are failed or ended with error:
(teststep\d+)_(?:failed|error)

I used Regex Extractor (for Output choose List) node from Palladian extension but maybe you can try it with some base KNIME node like Regex Split or regexReplace() function from String Manipulation node.

Br,
Ivan

[simonmng]

that was great help for me thank you!