EOL calculating field, single quoted - scrubbing addresses

Question

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 gp.CalculateField_management(fc + "\Parcels.shp", "SIT_FULL_S", "myfunction(!SIT_HSE_NU!,!SIT_FULL_S!)", "PYTHON", "def myfunction(fld1,fld2): if (fld1=='0'or fld1=='00'or fld1<'00000000000'): return '' else: return fld2") arcgisscripting.ExecuteError: ERROR 000539: Error running expression: myfunction("69","69 FLOOD ST ") : EOL while scanning single-quoted 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 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() : EOL while scanning single-quoted string (, line 1) Failed to execute (CalculateField).

TurnerNowak · Answer

Missing indentation in your function block's return statements:"def myfunction(fld1,fld2): if (fld1=='0'or fld1=='00'or fld1<'00000000000'): return '' else: 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 ERROR 000539: Error running expression: myfunction (" ","69 FLOOD ST ") : EOL while scanning single-quoted string (, line 1) Failed to execute (CalculateField).

JasonScheirer · Answer

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

TurnerNowak · Answer

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 gp.CalculateField_management(fc + "\Parcels.shp", "SIT_FULL_S", "myfunction (!SIT_HSE_NU!,""!SIT_FULL_S!"")", "PYTHON", "def myfunction(fld1,fld2): if (fld1=='0'or fld1=='00'or fld1<'00000000000'): return '' else: return f ld2") arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid. ERROR 000989: Python syntax error: Parsing error : expected an indented block (line 3) Failed to execute (CalculateField).