Is there a Python expression for Does Not Contain that I can use in a Update Cursor? I am looking for the '@' symbol in a column within a table (not a FC) and want to delete all entries without one, is there a way accomplish this?
For the WHERE clause in your Update Cursor use
myField NOT LIKE '%@%'
The '%' sign is a wildcard character representing any number of characters, including 0 characters.
The call would look something like this.
cursor = arcpy.da.UpdateCursor(contacts, #your table ['*'], #your fields "Contact_Email NOT LIKE '%@%'") #your where clause for row in cursor: cursor.deleteRow() del cursor