Convert a string to lowercase and put the first letter of each word in uppercase, using the field calculator

6002
2
Jump to solution
09-29-2014 09:18 AM
GustavoCordero
New Contributor III

I am using arcgis 10.2.2

 

 

I have a field in my attribute table called "name" and there is written all in capitals other attributes only lowercase.

 

I need my attributes standardize leaving only the first letter of each word in uppercase

 

 

example 1:

 

      Name        |

JOSE LUIS

maria jose

 

example 2 standardized:

 

    Name         |

 

Jose Luis

Maria Jose

1 Solution

Accepted Solutions
JerredSchmidt
New Contributor III

Use the python string function .title(). This will capitalize the first letter of every word in your string making the rest lowercase.

Example

"TEST TEST TEST" becomes "Test Test Test"

python_title_calculator.JPG

View solution in original post

2 Replies
JerredSchmidt
New Contributor III

Use the python string function .title(). This will capitalize the first letter of every word in your string making the rest lowercase.

Example

"TEST TEST TEST" becomes "Test Test Test"

python_title_calculator.JPG

SSMIC3038
Occasional Contributor III

Great tool, thanks for sharing this.

0 Kudos