table help

375
1
09-27-2011 11:09 AM
CalebMackey2
New Contributor
I have a shapefile for major rivers in Iowa and when I went to label them I experienced a problem. This shapefile was pulled from the Iowa Natural Resources GIS website and the river names were in all caps. I was able to use field calculator to convert all the labels into lower case, however, I am trying to see if there is a way to capitalize only the first letter. There are 1781 records so I do not really want to manually fix all of them. Also, some of the rivers have two word names. Basically I am wondering if there is an expression I can write to capitalize the first letter of every word in my river name field?
Tags (2)
0 Kudos
1 Reply
CalebMackey2
New Contributor
Nevermind, found it. I used this python script      !CO_NAME!.title()
Just in case someone else has the same problem try the above expression (for Arc10).
0 Kudos