[resolved] tFilterRow Advance Mode Error

[jdlo_25]

Hi Guys,
Good Day! 
I'm trying to work on a project where I need to filter a row with some string on a specific column like "Not". I used the advance mode of the tfilterrow and define the condition: 
input_row.ColumnName.indexOf("Not") == -1 I also tried !input_row.ColumnName.contains("Not") 
and it seems to filter out the row with the string on the column on it but it also filter out some rows that has no "Not" on that column.
I figure it out using the rejects output of the tfilterRow because I include the error message and some rows is an error because of the advance condition that I set up.
Is there any more accurate way to filter it out? 
Thanks In Advance
Regards
John 

[Anonymous · Accepted solution]

Hi
The expression is used to filter all the rows that don't contains "Not", what are your expected result? An example will be helpful for us to understand the request. 

Regards
Shong