HOW TO

Convert upper case words to lower case in a string field

Last Published: April 25, 2020

Summary

You can use the Lcase request to change all characters in a string field to lower case.

Note:
The information in this article applies only to retired products, ArcView GIS versions 3.x.The instructions described apply to the Avenue programming language, which is specific to the ArcView GIS application.

For ArcMap and ArcGIS Pro, this procedure can be done using a Visual Basic or Python expression. In ArcMap or Pro, open the Field Calculator, and click 'About calculating fields' for examples of field calculations.

Procedure

  1. Open the table.
  2. Select Start Editing from the Table menu.
  3. Select the field heading of the field that you want to change to lower case.
  4. Click the Field Calculator button.
    [O-Image] Field Calculator Button
  5. Double-click the field name to convert from the Fields list.
  6. Scroll down the Requests list and double-click Lcase.
  7. Click OK.
The final expression should look similar to the following:
Code:
[State_name].LCase
  1. Select Stop Editing from the Table menu.
  2. Save your edits when prompted.

Article ID:000004822

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic