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; } } }

Having trouble creating an expression for CalculateField()

GeoDev

arcpy.management.CalculateField(CAD_Anno, "SymbolID", "!SymbolID!.replace('0', '1')", "PYTHON3")

Here is the syntax I wrote and the corresponding Error. I'm decent at python, but I am so confused about how to get this expression working. Basically, in the field of "SymbolID" I want to replace all the 0s with 1s. So the pseudocode would be "If there is a 0 in this current row of the field SymbolID, then replace it with a 1"

Traceback (most recent call last):
File "C:/Users/ggroshans/Desktop/append.py", line 14, in <module>
arcpy.management.CalculateField(CAD_Anno, "SymbolID", "!SymbolID!.replace('0', '1')", "PYTHON3")
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 5194, in CalculateField
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 5191, in CalculateField
retval = convertArcObjectToPythonObject(gp.CalculateField_management(*gp_fixargs((in_table, field, expression, expression_type, code_block, field_type, enforce_domains), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 000539: File "<expression>", line 1
0.replace('0', '1')
^
SyntaxError: invalid syntax

Failed to execute (CalculateField).

Find more posts tagged with

Accepted answers

All comments

TomaszTARCHALSKI1

Hi,

your field is type of Integer or string? if integer, you cannot search and replace strings.

instead of calculcate field, you can also (which is faster by the way) use arcpy.da.UpdateCursor

if your field is integer, you can simply (within cursor) check if your value is equal to 0 or not.

GeoDev

I tried converting it to string and got this error now:

JayantaPoddar

The issue could be !SymbolID! is a numeric field.

Could you replace

"!SymbolID!.replace('0', '1')"

with

str(!SymbolID!).replace('0','1')

GeoDev

I'm executing it via standalone script in PyCharm. I have PyCharm connected
to the Python 3.7 (arcgispro-py3) environment.

JoshuaBixby

How are you executing the code? As a standalone script outside of Pro, a script tool in Pro, the interactive Python window in Pro, Jupyter notebook, etc...?

GeoDev

I am also on ArcGIS Pro 2.8.0. Not sure how yours worked and mine is
getting this error message.

JoshuaBixby

I just tested a similar code snippet in Pro 2.8.0, and everything worked as expected, i.e., no error and expected results. What desktop client and version are you using?

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.