Delete rows based on content of field

[guyatisk]

In power query, is there a way to remove rows if a certain string is contained in a field?  So if "abc" or "xyz" exist in a field named "Charge", I do not want that ending up in the dataset.  Is there a way to filter/remove those rows?  Thanks for the information

[guyatisk · Accepted solution]

Found it - 

Table.SelectRows(#"Added custom 3", each not Text.Contains([Charge], "ABC") or [Charge] <> "XYZ"))

I will keep this here for anyone who might need it