nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Field Calculate syntax error

2Quiker

Trying to figure out a simple field calculate but I can't i keep getting syntax error. This is a shapefile.

I need to update the updateField field. The updateField is a text field.

def Reclass(SC):
    if (SC == "GR"):
        return = GRAIN
    if (SC == "WR"):
        return = WRITE
    if (SC == "PL"):
        return = PLACE

updateField = Reclass(!SC!)

Find more posts tagged with

Accepted answers

All comments

2Quiker

Man I could not get the field calculator to work, I kept getting that I have a syntax error.

I ended up just using the python window with updatecursor.

import arcpy


fc = "layer"

with arcpy.da.UpdateCursor(fc,["SC","SC2"]) as cursor:
    for row in cursor:
        if row[0] not in (None, "", " "):
            if row [0] == "GR":
                row [1]= "GRAIN"
            elif row [0] == "WR":
                row [1] = "WRITE"
            elif row [0] == "PL":
                row [1] = "PLACE"
            cursor.updateRow(row)
        else:
            pass

2Quiker

Using what you posted if SC is not None: but still have me the error "The field is not nullable". So I check the attributes filed and there are some blanks and nulls. I am trying to run this on the how feature class table not just the selected features.

def Reclass(SC):
 if SC not in [None, "", " "]:
    if (SC == "GR"):
        return "GRAIN"
    elif (SC == "WR"):
        return "WRITE"
    elif (SC == "PL"):
        return "PLACE"

updateField = Reclass(!SC!)

AdrianWelsh

What do you want to do with nulls? Leave them null? The python syntax for null is "None".

So you could write something like:

if SC is not None:

If (SC == "GR"):

return "GRAIN"

elif .... and so on

2Quiker

It was in vbscript, so I though I had it figured out but I guess not. The following only works with one if but when adding more elif I get an error that field is not nullable. How do I handle Nulls and blanks in field calculator? The SC field dose have some nulls and blanks.

def Reclass(SC):
    if (SC == "GR"):
        return "GRAIN"
    elif (SC == "WR"):
        return "WRITE"
    elif (SC == "PL"):
        return "PLACE"

updateField = Reclass(!SC!)

AdrianWelsh

Oh no! Was it in vbscript or Arcade? At least you got it figured out!

2Quiker

Total rookie mistake, I forgot to check the python parser box.

2Quiker

I have tried it with quotes and still get the syntax error.

def Reclass(SC):
    if (SC == "GR"):
        return "GRAIN"
    if (SC == "WR"):
        return "WRITE"
    if (SC == "PL"):
        return "PLACE"

updateField = Reclass(!SC!)

Anonymous User

Hello 2Quiker,

Does the syntax error identify a certain line of code?

I wonder if your return statements need to also be in quotations to be returned as text. "GRAIN" instead of GRAIN.

Cheers,

Mike

AdrianWelsh

If you're trying to return text, do you need quotes around your text returns?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.