topic Re: String to Numeric (11 characters) Issue in ArcGIS Pro Questions

String to Numeric (11 characters) Issue

miminuton — Thu, 07 Jul 2022 21:32:02 GMT

Hello,

I am using ArcGIS Pro Version 2.6 and am trying to convert geoid (11 figures) from a string to numeric through the attribute table and calculate field. I have tried the following methods and it creates a new variable with only 10 figures and null values (when there are 11 figures).

To denote that length is 11
Calculate field where !variable!
.zfill(11)

All of these have left me with many null values and only 10 digits in my number.

Is there any way I can go about doing this?

Thank you so much!

Re: String to Numeric (11 characters) Issue

DavidSolari — Thu, 07 Jul 2022 21:54:54 GMT

Are you converting a text field to a long integer field? The maximum value of a long field is (2^31)-1, or 2,147,483,647, which is 9 consistent decimal digits, or 10 in some cases. To store numeric versions of larger numbers, use a "double" field, that gives you 15 consistent decimal digits with no precision loss. Here's a quick field calculator example (the long field is null because the value causes the calculation to fail due to size restrictions):

Re: String to Numeric (11 characters) Issue

EvanThoms — Thu, 07 Jul 2022 22:02:49 GMT

Ah! census geographic identifiers, not globe models, right?

I set up a table with the following fields and datatypes

and then wrote an 11 character census tract to geoid_string, 48201223100

Running the field calculation

int(!geoid_string!)

on each of the fields resulted in:

I am guessing you are trying to calculate on a long integer field? Try setting it to double and using the calculation above.

Read more about the limits on datatypes here:

ArcGIS field data types—ArcGIS Pro | Documentation

Re: String to Numeric (11 characters) Issue

JayantaPoddar — Thu, 07 Jul 2022 23:08:22 GMT

Could you share screenshot of how the different string values look like, and explain what portion of string you would like to extract?