Home » GIS Analysis » How to Capitalize the First Letter in a Field Using Python in ArcGIS

How to Capitalize the First Letter in a Field Using Python in ArcGIS

San Francisco Capitalize

Capitalize words using Python

If your letters and words are all uppercase or lowercase in a field, and you want to capitalize the first letter of each word…

…We have some straight-forward Python code just for you.

…And all you’ll need is the field calculator in ArcGIS (ArcMap) combined with a bit of Python.

This step-by-step guide will help you get started:

What this tutorial will accomplish

We will simply take any field, and change the first character to a capital letter. The other letters in the word will be lower case.

For example:

  • SAN FRANCISCO will become San Francisco
  • san francisco will become San Francisco
  • saN fRaNciSCo will become San Francisco

….So the first letter will be capitalized using some Python code.

We use the .title() string operator in Python to accomplish our objective.

Step 1: Create a new text field called “Capitals”

This text field will be used to store the capitalized words. Make the text length property large enough to hold all of the text from the other field.

Add Field

Now, there should be a new text field called capitals in your table:

Capitals New Field

Step 2: Use field calculator

Right-click the new field “Capitals”.

Select the ‘Field Calculator’ option.

Field Calculator

Step 3: Enter Python code

First, select the Python radio button.

In the expression text box, double-click the field with the existing text field that you want to capitalize the first letter. Type .title() after the field and press OK.

Here’s an example of the field calculator code block:

Python Code Title

If you see the result, it has a new field with capital letters.

Capitals Field Calculator Result

If you’re getting an error, try to the following:

  • Run this python code block by selecting the records first.
  • Do not capitalize .title() with a capital ‘T’

Capital letter results with ArcMap and Python

Python has a simple solution to capitalize the first letter in a text field.

You can also convert strings to all lowercase in a text field using the .lower() property. The .upper() returns a copy of a string with all the cases characters converted to uppercase.

From titles to lowercase to uppercase….

Use these handy Python string operators as huge time-savers for your big data sets.

READ MORE: 10 Python Libraries for GIS and Mapping

Leave a Reply

Your email address will not be published. Required fields are marked *