12.05.2013

Formatting content in vbcsript adding new line

In ArcMap labelling, I need to parse the label into Customer Name and its account number with the account number appearing after new line:

I used the code vbNewLine and it worked fine.

[CUBAOmeters.CUSTOMER] & vbNewLine &  [CUBAOmeters.CAN] 

12.02.2013

Creating a new field with attributes incrementing by 1


pre-logic script code:

rec=0
def autoIncrement( ):
 global rec
 pStart = 1 
 pInterval = 1 
 if (rec == 0): 
  rec = pStart 
 else: 
  rec = rec + pInterval 
 return rec



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 )