Row filter doubt

[FabioGuimaraes]

Hi Guys

I know that is easy but please help me.

I would like to consider in my database just rows that contain numbers(codes).
I tryed to use row filter excluding what started with COL but doesnt work.
Maybe if there is a way to filter just numbers in the column, not so sure…

Please, check the column that I want to filter attached.

All the best

[elsamuel]

Can you show us what you’ve tried?

[FabioGuimaraes]

Just a simple column expression filtering first 3 leters. After that, a few row filters filtering rows with Col, Rows with “fornecedor” and so on…

It works, but its not the best case scenario.

[ipazin]

Hello @FabioGuimaraes,

you would like to filter based on values from Row ID column? If so what is the pattern? Everything that start with COL should be excluded and everything else included or?

Br,
Ivan

[Charm_Myae]

Hi… @FabioGuimaraes
May I suggest a way.

(1) Use string manipulation node.
substr($column$, 0, 3)

(2) Use row splitter node.
use pattern, enter “COL” in box, tick case sensitive match

You can use 2 output. Start with COL and Other.

Regards,
Charm

[FabioGuimaraes]

Good approach!
More or less similar mine but using 2 nodes.
Tks

[FabioGuimaraes]

Hi @ipazin
Just numbers should be maintained in this column.
Tks!

[Daniel_Weikert]

would go with a regex

config:
\d+

[FabioGuimaraes]

Sounds nice! Let me try
all the best