topic Re: Field Calculate syntax error in Python Questions

Field Calculate syntax error

2Quiker — Fri, 14 Jan 2022 19:04:21 GMT

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!)

Re: Field Calculate syntax error

AdrianWelsh — Fri, 14 Jan 2022 19:15:53 GMT

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

Re: Field Calculate syntax error

Anonymous User — Fri, 14 Jan 2022 19:17:12 GMT

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

Re: Field Calculate syntax error

2Quiker — Fri, 14 Jan 2022 19:37:54 GMT

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!)

Re: Field Calculate syntax error

2Quiker — Fri, 14 Jan 2022 19:41:42 GMT

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

Re: Field Calculate syntax error

AdrianWelsh — Fri, 14 Jan 2022 19:50:58 GMT

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

Re: Field Calculate syntax error

2Quiker — Fri, 14 Jan 2022 20:06:49 GMT

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!)

Re: Field Calculate syntax error

AdrianWelsh — Fri, 14 Jan 2022 20:15:36 GMT

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

Re: Field Calculate syntax error

2Quiker — Fri, 14 Jan 2022 21:14:41 GMT

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!)

Re: Field Calculate syntax error

DanPatterson — Fri, 14 Jan 2022 21:25:45 GMT

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

you need to tell it what to do if there is one of those no-no cases

Re: Field Calculate syntax error

2Quiker — Wed, 19 Jan 2022 17:19:54 GMT

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