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.

If I click on the empty space a popup is brought, but I dont seem to know where to place it. http://imgur.com/85Asvk9 — Enrique Bravo, Feb 04 '16 at 23:58

Seb · Answer 1 · 2016-02-05T08:30:14.693

1

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

edited Feb 05 '16 at 08:30

answered Feb 05 '16 at 08:15

Seb

329
1
8

Pentaho Filter Regexp Excel Input

1 Answers1