Is there a Python expression for Does Not Contain that I can use in a Update Cursor?

Question

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?

Answer 1

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