arcgis-desktopfield-calculatorpython-parser
I would like to create an expression using the field calculator in ArcMap to be able to convert an Int field to a string and add leading zeroes.
I am able to do it in a python window with an example
x=450
print str(x).zfill(4)
>>>0450
I have tried:
!Time!.str().zfill(4)
but that gives me invalid syntax errors.
For VB, something like this should work, I think:
Pre-logic script code:
Dim f2 As Double
If [grid_code] = 1 Then
f2 = 2
ElseIf [grid_code] = 2 Then
f2 = 3.5
End If
asp_code =
f2
In Python, I think it would be something like this (though I don't have ArcGIS 10 so I can't check):
Pre-logic script code:
def my_func(my_field):
if my_field == 1:
f2 = 2
elif my_field == 2:
f2 = 3.5
return f2
asp_code =
my_func(!grid_code!)
The error message saying that the "calculated value is invalid" is a bit strange. Perhaps double-check that your asp_code field is of float or double data type (not integer), and that you have all of the options in the grid_code field covered by your if statements? Sorry if that's too obvious, but it's all I can think of at the moment. Good luck!
if !myField! == 'NULL' will not test for a null value. That will test a for a string equal to 'NULL'. Use:
if !myField! is None:
To accomlish your task, define a python function in the pre-logic code block and use that function in the expression window. The following code sample pulls the first token from a '-' delimited string.
Best Answer
stris a class, not a method, so you need to do:This should work if the
Timefield is an integer. If it's afloator other type, you will need to recast it as anint.