Unable to extract the first six characters of a string using Calculate Field

08-10-2021 10:35 AM
New Contributor III

Hello I'm using arcgis pro. I opened up a feature layer in a geodatabase, and I would like to extract the first six characters of the GEOID (string2.png). I have checked that the field type of GEOID is text. I created a new field called "GEOID_5", and I made it a text field too. Then I right-clicked the field, then clicked "Calculate Field", and then put in the following formula (string.png). I'm sure the formula is correct because I borrowed it from a similar case in https://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/calculate-field-examples.htm. However, after the calculation, all the entries in GEOID_5 is <Null>. I was wondering whether anyone would offer me some thoughts. Thank you.

0 Kudos
10 Replies
Occasional Contributor

Thanks @JoeBorgione.  Sounds like some inexplicable problem that a good old fashioned turn off and turn on fixed.