topic Re: Convert a string to lowercase and put the first letter of each word in uppercase, using the field calculator in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/convert-a-string-to-lowercase-and-put-the-first/m-p/94867#M3268 <HTML><HEAD></HEAD><BODY><P>Use the python string function .title(). This will capitalize the first letter of every word in your string making the rest lowercase.</P><P></P><P>Example</P><P>"TEST TEST TEST" becomes "Test Test Test"</P><P></P><P><IMG __jive_id="16412" alt="python_title_calculator.JPG" class="jive-image image-1" src="https://community.esri.com/legacyfs/online/16412_python_title_calculator.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 29 Sep 2014 16:35:14 GMT JerredSchmidt 2014-09-29T16:35:14Z Convert a string to lowercase and put the first letter of each word in uppercase, using the field calculator https://community.esri.com/t5/geoprocessing-questions/convert-a-string-to-lowercase-and-put-the-first/m-p/94866#M3267 <HTML><HEAD></HEAD><BODY><P>I am using arcgis 10.2.2 </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I have a field in my attribute table called "name" and there is written all in capitals other attributes only lowercase.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I need my attributes standardize leaving only the first letter of each word in uppercase</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>example 1:</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</P><P>JOSE LUIS</P><P>maria jose</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>example 2 standardized:</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>&nbsp;&nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Jose Luis</P><P>Maria Jose</P></BODY></HTML> Mon, 29 Sep 2014 16:18:36 GMT https://community.esri.com/t5/geoprocessing-questions/convert-a-string-to-lowercase-and-put-the-first/m-p/94866#M3267 GustavoCordero 2014-09-29T16:18:36Z Re: Convert a string to lowercase and put the first letter of each word in uppercase, using the field calculator https://community.esri.com/t5/geoprocessing-questions/convert-a-string-to-lowercase-and-put-the-first/m-p/94867#M3268 <HTML><HEAD></HEAD><BODY><P>Use the python string function .title(). This will capitalize the first letter of every word in your string making the rest lowercase.</P><P></P><P>Example</P><P>"TEST TEST TEST" becomes "Test Test Test"</P><P></P><P><IMG __jive_id="16412" alt="python_title_calculator.JPG" class="jive-image image-1" src="https://community.esri.com/legacyfs/online/16412_python_title_calculator.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 29 Sep 2014 16:35:14 GMT https://community.esri.com/t5/geoprocessing-questions/convert-a-string-to-lowercase-and-put-the-first/m-p/94867#M3268 JerredSchmidt 2014-09-29T16:35:14Z Re: Convert a string to lowercase and put the first letter of each word in uppercase, using the field calculator https://community.esri.com/t5/geoprocessing-questions/convert-a-string-to-lowercase-and-put-the-first/m-p/94868#M3269 <HTML><HEAD></HEAD><BODY><P>Great tool, thanks for sharing this.</P></BODY></HTML> Wed, 13 Jun 2018 13:34:03 GMT https://community.esri.com/t5/geoprocessing-questions/convert-a-string-to-lowercase-and-put-the-first/m-p/94868#M3269 SSMIC3038 2018-06-13T13:34:03Z