You don't need all the complications of defining a function as a string. Just create the function in the codeblock and use a simple expression that uses the function. Indents and extra lines will be honoured. Calculator is very bad at handling data errors. If your expressions result in an exception, then you won't get any feedback. Better to use a cursor in a script and trap the errors so you can see the faulty data. It is just as fast, because a cursor implements your expression anyway.codeblock that goes in the box :def getvalue(string):
valuelist=string.split(',')
valueset=set(valuelist)
value=str(valueset)[5:-2]
value.replace('"','') # not sure what you are trying to replace - a double quote?
return valueexpression in the box:getvalue(!parce_test_spatial_join.FLD_ZONE!)
Maybe a python script equivalent:
import arcpy
cur = arcpy.UpdateCursor("parce_test_spatial_join")
try:
for row in cur:
value = row.fld_zone
valuelist=string.split(',')
valueset=set(valuelist)
value=str(valueset)[5:-2]
value.replace('"','')
row.target_field = value # enter your own field here
cur.updateRow(row)
del cur
except :
print "failure on ",value
