Node Google Sheets | How locate lines that contains (not equal) part of a text

Questions
,
#1

Hi Community

Using Google Sheets, How can Ilocate lines that contains (not equal) part of a text…

For example…

In a list of Full Names, like:

#1 Evandro Luis Caruso
#2 João da Silva
#3 Pedro dos Santos Soares
#4 Enzo Ribeiro Caruso

How can I read, or filter the lines that contains “Caruso”…

Of course, without read all lines…

#2

Hi @Evandro_Caruso, I don’t think there is an way using the Google Sheets node here that would not require reading all rows and then utilizing an IF node for this task. The Sheets node itself would only allow you to check if a field contains a specific value, not the opposite.