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

[RichardStieg]

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

[IanMurray · Accepted solution]

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.