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
Can you show us what you’ve tried?
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.
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?
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.
More or less similar mine but using 2 nodes.
Just numbers should be maintained in this column.
Sounds nice! Let me try
all the best
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.