topic Re: Calculating Field in Geoprocessing Questions

Calculating Field

MichelleCouden — Thu, 22 Jan 2015 21:25:55 GMT

I have 2 fields I need to concatenate together and add zeros and a hypen.

For Example: 0001-02

In the past this code worked :

"00{0}-0{1}".format(int(!ACONTROL!)),int(!ASECTION!))

This time I am getting an error of :

SyntaxError: unexpected EOF while parsing(<string>, line 1)

My empty field I created is a text. The AControl field is a double and the ASection field is a double.

Why is my code not working this time? What have I changed? Please help. THanks!

XanderBakker — Thu, 22 Jan 2015 23:43:19 GMT

It is not something that is missing... you have a parenthesis too much:

"00{0}-0{1}".format(int(!ACONTROL!),int(!ASECTION!))

XanderBakker — Fri, 23 Jan 2015 00:04:23 GMT

If you want to make it a little more robust, but slightly more complex you could use:

"{0}-{1}".format("{0}".format(int(!ACONTROL!)).zfill(4),"{0}".format(int(!ASECTION!)).zfill(2))

This will yield:

as the first suggestion will yield:

MichelleCouden — Mon, 26 Jan 2015 15:48:45 GMT

Thank You xander for your help. The second code worked great!!

XanderBakker — Mon, 26 Jan 2015 15:56:29 GMT

Glad it worked!