[GIS] How to convert field values from lower case to upper case in ArcGIS 10.1

arcgis-10.1arcmappythonvbscript

Using the Field Calculator in ArcGIS 10.1, I am able convert the first letter in a value from lower case to upper case. How do you convert the entire value to upper case, though? I can't seem to locate a VBScript for it.

For example, I want to convert small to SMALL.

Best Answer

Another alternative using Python would be:

!fieldname!.upper()

as described in the online help Calculate Field examples.

Related Solutions

[GIS] ArcGIS field calculator: VBScript get data from previous row

This script is from the Easy Calculate 5.0 Scripts by Ianko Tchoukanski

This section goes in the code block. Set the lInterval and lStart values as necessary. In this case, lInterval = 5 and lStart = 0.

Static rec As Long
Static i As Long
Dim lStart As Long
Dim lInterval As Long
'=================
'adjust start value and interval below
lStart =  0
lInterval = 5
'=================
If (i = 0) Then
  rec = lStart
Else
  rec = rec + lInterval
End If
i = i + 1

Place this in the [Field Name] = area:

rec

ArcPy & Python – Converting Case of All Values in Table Fields

The following example shows how to integrate the built-in python method .upper() with the arcpy update cursor. This example first tests if a field is of type String then checks each row within that string for lowercase values. If there are lower case values, the row is updated with all upper case.

import arcpy

fc = r'C:\temp\test.gdb\yourFC'

desc = arcpy.Describe(fc)
fields = desc.fields

for field in fields:
    if field.Type == "String":
        with arcpy.da.UpdateCursor(fc, str(field.name)) as cursor:
            for row in cursor:
                if row[0] == None:  # Check for "<Null>"
                    continue
                else:
                    any(x.islower() for x in row[0]) == True
                    row[0] = row[0].upper()
                    cursor.updateRow(row)

Best Answer

Related Solutions

[GIS] ArcGIS field calculator: VBScript get data from previous row

ArcPy & Python – Converting Case of All Values in Table Fields

Related Question