copying a text field into an empty double precision field in a table

RichardStieg — Wed, 12 Aug 2015 18:48:06 GMT

I am trying to create a parcel fabric line feature class in the Local Government Information Model. I get an error message stating that two existing fields were created as 'text' when the Parcel Fabric topology is expecting double precision. Since there are 1,645,728 individual property 'lines' in the base data, exporting into another software and importing back into the database (i.e. EXcel) won't work.

I remember seeing .AString or .ASnumber (or something similar) in earlier Table calculators that I used to fix similar problems.

Any help would be appreciated.

Rick Stieg GISP

Shelby County Government

Re: copying a text field into an empty double precision field in a table

IanMurray — Wed, 12 Aug 2015 19:33:37 GMT

if you use python as a parser for the field calculator it should be as simple as:

DoubleField = float(!TextField!)

should convert your string values to floats, as long as the string is composed on only numbers and decimals.

topic Re: copying a text field into an empty double precision field in a table in State & Local Government Questions

copying a text field into an empty double precision field in a table

Re: copying a text field into an empty double precision field in a table