HOW TO

Convert upper case words to lower case in a string field in ArcGIS Pro

Last Published: July 18, 2023

Summary

When using string functions such as title or replace in the Calculate Fields tool to replace an upper case letter with a lower case in a string field, only specific letters are replaced. To convert all upper case letters in a string field to lower case, use the .lower() function instead.

In this example, all the upper case letters under the CITY field of the attribute table are converted to lower case.

Procedure

Complete the steps below to convert all the upper case letters in a string field to lower case using the Calculate Fields tool.

  1. Open the project in ArcGIS Pro.
  2. In the Contents pane, right-click the layer with the attribute table, and click Attribute Table.
  3. In the attribute table, right-click the field with the upper case letters to be converted, and click Calculate Field Calculate Field. Ensure the Expression Type is Python3.
  4. Under the Expression section in the Calculate Field pane, select the field under Fields, and select the .lower() function from the Helpers list.
Note:
Set the filter to Text helper type to make the search for the .lower() function easier.

The expression reads as follows:

!<layer name>!.lower()

In this example, the expression reads:

!CITY!.lower()
Expression pane
  1. Click Run. When the tool completes, all the upper case letters of the field are converted to lower case.
Upper case letters converted to lower case
  1. Click the Save Edits button Save Edits button in the Calculate Field pane to save the changes.

Article ID: 000022867

Software:
  • ArcGIS Pro 2 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options