[GIS] Removing extra string from text column in Attribute Table to make numeric column from number part using ArcGIS Field Calculator

arcgis-10.2arcgis-desktopattribute-tablefield-calculator

I received a shapefile about invasive species. I am using ArcGIS 10.2 for desktop. In Attribute Table, there is column called "Infested_Area" and its got number mix with text, for instance "9100 sq feet". Since I can not run statistic on string I was wondering if it's possible to create a new filed and somehow get rid of the text portion of it and only have number!

Best Answer

This is similar to @PolyGeo solution

but will handle different units and unitless entries

!TextField!.split(" ")[0]

Note you cannot run statistics on result, if units are different

Related Solutions

ArcGIS – Rounding Column in Attribute Table Using Field Calculator

Have you tried something like what's below in the Field Calculator?

round(!FieldName!, 2)

Make sure you set the Parser to Python in the Field Calculator.

[GIS] Concatenating string data plus numeric data in ArcMap field calculator

No need to write a function here. Just hit the Python radio button, and then write this into the box:

 Address: + " " + str(!Address_No!) + " " + !StreetName! + " " + !Street_Ty!

What is important:
- field names are represented by their name but embraced by exclamation points: !
- any numeric field needs to be converted to a string when concatenating with other strings. To do that in Python, use the str() function. Anything within the parentheses will be converted o a string, even if it is a number
- You should add blank characters (" ") between your parts, to format this nicely, so it appears like: Address: 1 Main ST instead of Address:1MainST

Best Answer

Related Solutions

ArcGIS – Rounding Column in Attribute Table Using Field Calculator

[GIS] Concatenating string data plus numeric data in ArcMap field calculator

Related Question