TaskPipes will be shutting down 30th November 2018. Please migrate any processes to an alternative solution before then.

How to delete a row if it contains certain text

This is extremely simple in TaskPipes.

Just add a filter step, define the column of interest, and use the "does not contain" criteria: