One Star

Filter Rows by Substring

I want to filter out rows if "total" or "sub total" is found in the test from a particular column.
Since this is a substring I am looking for I wasn't sure what the best approach was.
Thanks,
2 REPLIES
Seven Stars

Re: Filter Rows by Substring

Use tFilterRow with an advanced condition like:
input_row.columnName.contains("total")
One Star

Re: Filter Rows by Substring

Use tFilterRow with an advanced condition like:
input_row.columnName.contains("total")

Thanks Alevy. I stumbled across it (had to scroll in the panel to see it) and got it to works.
Thanks Again!