8.14.2013

Using wild card in Select by attribute for ArcGIS

Documenting:

Using wildcard in Select by Attribute for ArcGIS:

> Use %

Sample:

"LastName" LIKE '%REALTY%'

Removing string character from Field for FIELD CALCULATOR in ArcGIS

Documenting:

I want to remove String character "m" from the ELEVATION contour shapefile and convert String field to numerical Int or Double to get value of contour for geoprocessing.

In ArcGIS 10.1,

> create a new field containing length of string  : "LEN" 
     > calculate using Feild Calculator String Function len( )
         > len ( ELEVATION)

> Double field ELEV can be calculated

     > Left( [ELEVATION], [len]-1 )