Removing rows which contains less than or equal to three words

[MajidAbbasi]

Hello,
I have some sentences and I want to remove the rows which contain less than or equal to three words.

[izaychik63]

Look at String Manipulation node count() function.

[MajidAbbasi]

Thanks @izaychik63
In string manipulations node it is giving an option to count specific words in a string. How can I generalize it and count the number of any words in string?

[armingrudd]

Hi @MajidAbbasi,

Use this expression in a Rule-based Row Filter node and select “Exclude TRUE matches”:

$column1$ MATCHES "([^\s]+[\s]?){1,3}" => TRUE

This expression matches anything without white space as word. The expression below ignores single characters:

$column1$ MATCHES "((.\s)*[^\s]{2,}[\s]?(\s.)*){1,3}" => TRUE

If you need something else, please provide some examples.