topic table help in Data Management Questions https://community.esri.com/t5/data-management-questions/table-help/m-p/748674#M42109 <HTML><HEAD></HEAD><BODY><SPAN>I have a shapefile for major rivers in Iowa and when I went to label them I experienced a problem.&nbsp; This shapefile was pulled from the Iowa Natural Resources GIS website and the river names were in all caps.&nbsp; 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.&nbsp; There are 1781 records so I do not really want to manually fix all of them.&nbsp; Also, some of the rivers have two word names.&nbsp; 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?</SPAN></BODY></HTML> Tue, 27 Sep 2011 18:01:38 GMT CalebMackey2 2011-09-27T18:01:38Z table help https://community.esri.com/t5/data-management-questions/table-help/m-p/748674#M42109 <HTML><HEAD></HEAD><BODY><SPAN>I have a shapefile for major rivers in Iowa and when I went to label them I experienced a problem.&nbsp; This shapefile was pulled from the Iowa Natural Resources GIS website and the river names were in all caps.&nbsp; 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.&nbsp; There are 1781 records so I do not really want to manually fix all of them.&nbsp; Also, some of the rivers have two word names.&nbsp; 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?</SPAN></BODY></HTML> Tue, 27 Sep 2011 18:01:38 GMT https://community.esri.com/t5/data-management-questions/table-help/m-p/748674#M42109 CalebMackey2 2011-09-27T18:01:38Z Re: table help https://community.esri.com/t5/data-management-questions/table-help/m-p/748675#M42110 <HTML><HEAD></HEAD><BODY><SPAN>Nevermind, found it. I used this python script&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !CO_NAME!.title()</SPAN><BR /><SPAN>Just in case someone else has the same problem try the above expression (for Arc10).</SPAN></BODY></HTML> Tue, 27 Sep 2011 18:47:53 GMT https://community.esri.com/t5/data-management-questions/table-help/m-p/748675#M42110 CalebMackey2 2011-09-27T18:47:53Z