How to filter-in rows that contains a specific word

Hi,

can some suggest a node to filter the rows if they contain a specific word, like the example below the the word “car”:

row col1 col2
0. car test

  1. arpacar test
  2. note. test
  3. cara
  4. sat test

I want to filter in only the rows 0-1-3.

Hi @gujodm,
you can use row filter node and enter your criteria with wildcards and wildcards enabled.

BR

3 Likes

@morpheus Already tried. It does not work. I received 0 rows filter in and I know that the column_payment descriptions contain the word “testament”.

Hi @gujodm,

Using the word solely make the node search for an exact match. If you want to search for any value which contains the word “testament” in it, then you can use this wildcard:
*testament*

:blush:

5 Likes

Thank you! Now it works.

2 Likes

Hi @sw1336,

Would you please create a new topic for your question?

Thanks.
:blush:

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.