In ArcInfo 10.1 I have a table for each state with Zip Code values. The 5-digit Zip Codes that start with "0" have been reduced to 4-digits. I cannot figure out how to add a "0" to the front of all the values in the table. Tried a number of field-calculations but just can't seem to get it right.
[GIS] Adding “0” to front of all values in column using ArcGIS Field Calculator
arcgis-10.1arcgis-desktopfield-calculatorleading zero
Related Solutions
You could include the Python dictionary of state abbreviation:full-name pairs here
states = {
'AK': 'Alaska',
'AL': 'Alabama',
'AR': 'Arkansas',
# etc...
}
as the Codeblock in Field Calculator, and then use something like the following as the actual calculation:
!City! + ", " + states[!State!]
I should add that you could perform this calculation on either a new (text) field, or on the existing City field (or any other already-existing text field). I would recommend creating a new one, as you will otherwise not be able to easily revert to a field of only city names if you ever need them.
Open the Field Calculator, set to use Python Parser, and enter the following expression:
datetime.datetime(1899, 12, 30) + datetime.timedelta(days= !StartDate! )
There is potential if you have dates between 1 Jan 1900 and 1 March 1900 that this will give an incorrect value due to Excel thinking 1900 was a leap year, but for anything after those dates this should work.
It is possible to work around the above bug, but if you don't have those dates then I wouldn't bother.
Credit: Code for this answer taken from Parsing serial date in ArcGIS for Desktop?
Best Answer
As Brian mentioned you will need to store the data in a text field. Then the field calculation is: right("00000" + [Existing_ZIP_CODE_FIELD],5)
this will ensure you have all of the necessary leading 0s up to 5 characters.