Model Builder to python. Error at calculate field function

helenchu — Sun, 12 Dec 2021 06:54:46 GMT

All,

My model works fine but when I export it to python I got syntax error SyntaxError: "EOL while scanning string literal" . Any idea why? I've tried many simple calculation functions. Got same errors for all. Thank you!

EX:

# Process: CalField_Ac (Calculate Field) (management)
ToAcres = arcpy.management.CalculateField(in_table=FromSqft, field="Acres", expression="round((float(!Sqft!)/43560),4)", expression_type="PYTHON3", code_block="", field_type="TEXT")[0]
‍‍

# Process: CalField_BlkNum (Calculate Field) (management)
Calculate_BlkNum = arcpy.management.CalculateField(in_table=myTable, field="Blk_Num", expression="fn(!Blk_Num!,!Acct_Num!)", expression_type="PYTHON3", code_block="def fn(Blk_Num,Acct_Num):
 if (Blk_Num) is not None:
 return Blk_Num 
 else:
 return 1
 ", field_type="TEXT")[0]‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Model Builder to python. Error at calculate field function

DanPatterson — Sun, 12 Dec 2021 06:54:48 GMT

Indentation is crucial for codeblocks. Triple quotes helps

code_block = """
def fn(Blk_Num, Acct_Num):
    if (Blk_Num) is not None:
        return Blk_Num 
    return 1
""" ‍‍‍‍‍‍

Re: Model Builder to python. Error at calculate field function

helenchu — Fri, 21 Aug 2020 11:31:22 GMT

That's it. Triple quotes solved my issue. Thank you so much Dan Patterson.

topic Re: Model Builder to python. Error at calculate field function in Python Questions

Model Builder to python. Error at calculate field function

Re: Model Builder to python. Error at calculate field function

Re: Model Builder to python. Error at calculate field function