[GIS] Converting text to proper case using ArcGIS field calculator

arcgis-desktopattribute-tablefield-calculatorpython-parser

I am working on a set of data that has over 40,000 records on ArcGIS and I want to use a Proper Case for several fields/columns on the table.

Is there a Python Script that can help me automate this process as I desire to save time while working on this records?

If you mean a capital letter at the start of each word you can use python's title method

str.title()

where str is your input field.

You can use this in field calculator on all records

Your need to convert your SQL into VBA or Python for the Field Calculator in ArcMap

ArcGIS 10 Users can also use Python scripts in ArcGIS Field Calculator

enter image description here

This is a cheaper option than buying ArcSDE and a database that supports SQL.

What you want to do in the codeblock for Python is define a function, and then call the function using your attributes as parameters as follows:

def comparison(left,right):
    if left < right:
        return left
    else:
        return right

output = comparison(!MIN_LEFT!,!MIN_RIGHT!)

Then, all you need in the calculation is output, as you already had for VBScript.