According to Add Field tool help:
Fields set as required are permanent and you will not be able to
delete them with future processing. To allow for deletion at a later
time set the field to non-required (the default).
I think you can try to make a copy of your feature class to convert required field to non required and then create a new integer field using data from text field.
Please, do the following:
- Create new short integer field.
- Right click on the integer field and call
Field calculator
.
- Check
Python
box
- Enter this code in field calculator (replace TEXT_FIELD with your field name, see pic for more details):
def convert(text):
try:
return int(text)
except:
return -9999
convert(!TEXT_FIELD!)
- Click
OK