topic Re: EOL calculating field, single quoted - scrubbing addresses in Python Questions

EOL calculating field, single quoted - scrubbing addresses

TurnerNowak — Tue, 10 May 2011 15:35:56 GMT

Would anyone be able to point me in the right direction ? I need to figure out how to either make the script ignore these errors and continue to run, or actually be able to handle these lines that currently shut down the script.

C:\ZP4>call housenumberzero.bat

C:\ZP4>C:\Python24\HOUSENUMERZERO.py
C:\ZP4\49003
C:\ZP4\49053
Traceback (most recent call last):
File "C:\Python24\HOUSENUMERZERO.py", line 21, in <module>
gp.CalculateField_management(fc + "\\Parcels.shp", "SIT_FULL_S", "myfunction(!SIT_HSE_NU!,!SIT_FULL_S!)", "PYTHON", "def myfunction(fld1,fld2):\n if (fld1=='0'or fld1=='00'or fld1<'00000000000'):\n return ''\n else:\n return fld2")
arcgisscripting.ExecuteError: ERROR 000539: Error running expression: myfunction("69","69 FLOOD ST

") <type 'exceptions.SyntaxError'>: EOL while scanning single-quoted string (<string>, line 1)
Failed to execute (CalculateField).

C:\ZP4>call 1LowerCaseSitusFull.bat

C:\ZP4>C:\Python24\SITUSLOWERPYTON.py
C:\ZP4\49003
C:\ZP4\49053
Traceback (most recent call last):
File "C:\Python24\SITUSLOWERPYTON.py", line 17, in <module>
gp.CalculateField_management(fc + "\\Parcels.shp", "SIT_FULL_S", "!SIT_FULL_S!.title()", "PYTHON", "")
arcgisscripting.ExecuteError: ERROR 000539: Error running expression: "69 FLOOD ST

".title() <type 'exceptions.SyntaxError'>: EOL while scanning single-quoted string (<string>, line 1)
Failed to execute (CalculateField).

Re: EOL calculating field, single quoted - scrubbing addresses

JasonScheirer — Sun, 12 Dec 2021 00:32:20 GMT

Try this:

gp.CalculateField_management(fc + "\\Parcels.shp", "SIT_FULL_S", "myfunction(!SIT_HSE_NU!,\"\"!SIT_FULL_S!\"\")", "PYTHON", "def myfunction(fld1,fld2):\n if (fld1=='0'or fld1=='00'or fld1<'00000000000'):\n return ''\n else:\n return fld2")

Re: EOL calculating field, single quoted - scrubbing addresses

TurnerNowak — Tue, 10 May 2011 16:22:56 GMT

Thanks, I tried that and here is what I got:

C:\ZP44\49053 situs batch errors
Traceback (most recent call last):
File "C:\Documents and Settings\Andrew\Desktop\Copy of HOUSENUMERZERO.py", lin
e 18, in <module>
gp.CalculateField_management(fc + "\\Parcels.shp", "SIT_FULL_S", "myfunction
(!SIT_HSE_NU!,\"\"!SIT_FULL_S!\"\")", "PYTHON", "def myfunction(fld1,fld2):\n if
(fld1=='0'or fld1=='00'or fld1<'00000000000'):\n return ''\n else:\n return f
ld2")
arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000989: Python syntax error: Parsing error <type 'exceptions.IndentationEr
ror'>: expected an indented block (line 3)
Failed to execute (CalculateField).

Re: EOL calculating field, single quoted - scrubbing addresses

JasonScheirer — Tue, 10 May 2011 20:16:51 GMT

Missing indentation in your function block's return statements:

"def myfunction(fld1,fld2):\n if (fld1=='0'or fld1=='00'or fld1<'00000000000'):\n   return ''\n else:\n   return fld2"

Re: EOL calculating field, single quoted - scrubbing addresses

TurnerNowak — Wed, 11 May 2011 16:38:54 GMT

Missing indentation in your function block's return statements:
"def myfunction(fld1,fld2):\n if (fld1=='0'or fld1=='00'or fld1<'00000000000'):\n   return ''\n else:\n   return fld2"

Thanks, I tried the above indentation but got this error:

Traceback (most recent call last):

File "C:\Documents and Settings\Andrew\Desktop\HOUSENUMERZERO.py", line 18, in
<module>

ERROR 000539: Error running expression: myfunction

(" ","69 FLOOD ST
") <type 'exceptions.SyntaxError'>: EOL while scanning single-quoted string (<st
ring>, line 1)

Failed to execute (CalculateField).