regex expression by row filter/ row splitter node

[handrym27]

Hi,

i try to filter data by regex expression but it doesnt match.
Here the example my data:
PT Sanjaya Tbk
PT Bintang

and the regex is Tbk$, i try on other platform as regex101 and the formula worked. but at row splitter by regex pattern it doesnt work. Is there something wrong?

[gab1one]

Hi @handrym27,

you need to use a regex pattern that matches the whole row you want to filter. In your case use .*Tbk$ to include rows that end on Tbk.

best,
Gabriel

[victor_palacios]

And if you have more regex questions, this workflow might help you by looking at concrete examples in KNIME: Various Examples of Regex in KNIME – KNIME Hub