I have two fields (
I'm having a problem creating a simple IF THEN Python statement in the Field Calculator box. I've been searching the threads for a similar example but to no avail. Basically the formula would work something like this.
If STREET1 contains "AVENUE", calculate AKA_STREET_TEST1 to "AVE", ELSE leave it blank
Below is my feeble attempt at creating the if-then statement.