Pentaho Filter Regexp Excel Input

Question

Ok, so what I'm trying to do now is take all the information off an Excel Input (all String columns), and then of these columns I want to make an specific filter for one of them, more specific on column NO_BIEN, this specific expression.

[0-9]+(.[0-9][0-9]?)?

I make a Filter Rows operation and click on the REGEXP filter but I don't see where can I paste the expression because all I can see if to add a String.

Answer 1

Place the regular expresssion in the filter-field "value"