Row Splitter - is regex working?

hi all,

I am tying to split rows based on a simple regex and I cannot make it work.
I even tried just filter by “.” which should return basically everything , still no success…

Can someone explain what Im doing wrong? To give you more info, I am generating the regex in the java format. In string manipulation worked perfectly, but not in row splitter.

thanks in advance!
M

Hi @matejek88,

could you share some data/workflow example/regex expression used? We cannot help if we cannot see the proeblem :slight_smile:

Have a nice day,
Raffaello Barri

2 Likes

chocolate,skimmed
chocolate,whole
low-fatyogurt0.0%,1l
full-creamyogurt,1l
longlifewhippingcream0,5,200g

I would like to have included in the filtered rows the ones above in bold.
The expression is the following: “[[:alpha:]]\D,\D[[:alpha:]]”
It perfectly works in regex101, but does nothing in knime.

thanks a mil!

Something like this?

Have a nice day,
Raffaello

3 Likes

regex would be sth like ^chocolate.*
but wildcard should also work chocolate*
br

1 Like

thanks a lot both, it worked now. I see what is now the logic in KNIME regarding regexes.

2 Likes

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