Select to view content in your preferred language

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

6835
2
Jump to solution
09-29-2014 09:18 AM
GustavoCordero
Deactivated User

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
Occasional Contributor

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
Occasional Contributor

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
Frequent Contributor

Great tool, thanks for sharing this.

0 Kudos