topic Re: how to change a field to proper case in Java Maps SDK Questions https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486245#M1494 <HTML><HEAD></HEAD><BODY><P>ArcGIS Pro:</P><P></P><P><A class="link-titled" href="http://pro.arcgis.com/en/pro-app/tool-reference/data-management/calculate-field-examples.htm" title="http://pro.arcgis.com/en/pro-app/tool-reference/data-management/calculate-field-examples.htm">Calculate Field Python examples—Data Management toolbox | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Thu, 17 Jan 2019 18:43:05 GMT JayJohnson2 2019-01-17T18:43:05Z how to change a field to proper case https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486241#M1490 <HTML><HEAD></HEAD><BODY><P>how to change a field in all caps to a new field in proper case</P></BODY></HTML> Fri, 02 Feb 2018 20:11:05 GMT https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486241#M1490 ScottRowland1 2018-02-02T20:11:05Z Re: how to change a field to proper case https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486242#M1491 <HTML><HEAD></HEAD><BODY><P>Here is the way to do this in Excel:</P><P></P><P><A class="link-titled" href="https://www.groovypost.com/howto/convert-text-uppercase-lowercase-capitalize-excel-2016/" title="https://www.groovypost.com/howto/convert-text-uppercase-lowercase-capitalize-excel-2016/">https://www.groovypost.com/howto/convert-text-uppercase-lowercase-capitalize-excel-2016/</A>&nbsp;</P></BODY></HTML> Thu, 17 Jan 2019 18:37:18 GMT https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486242#M1491 JayJohnson2 2019-01-17T18:37:18Z Re: how to change a field to proper case https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486243#M1492 <HTML><HEAD></HEAD><BODY><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #4d4d4d; font-family: Arial,Helvetica,sans-serif; font-size: 12.8px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; outline-color: invert; outline-style: none; outline-width: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; vertical-align: baseline; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px 0px 3.84px 0px; border: 0px none #4d4d4d;"><DIV style="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 12.8px; max-height: 500px; outline-color: invert; outline-style: none; outline-width: 0px; overflow: auto; vertical-align: baseline; padding: 0px; margin: 0px 0px 3.84px 0px; border: 0px none #4d4d4d;"><PRE style="background-color: #eeeeee; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 14.06px; line-height: 16.88px; outline-color: invert; outline-style: none; outline-width: 0px; overflow-x: auto; overflow-y: hidden; vertical-align: baseline; width: 1439.25px; padding: 10px 10px 25px 10px; margin: 0px 0px 0px 15px; border: 1px dashed #c2c4ba;"><CODE style="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 14.06px; outline-color: invert; outline-style: none; outline-width: 0px; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px none #4d4d4d;">Expression: ' '.join([i.capitalize() for i in !STATE_NAME!.split(' ')])&nbsp; Expression Type: PYTHON_9.3</CODE></PRE></DIV></DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #4d4d4d; font-family: Arial,Helvetica,sans-serif; font-size: 12.8px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; outline-color: invert; outline-style: none; outline-width: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; vertical-align: baseline; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px 0px 3.84px 0px; border: 0px none #4d4d4d;"><DIV style="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 12.8px; outline-color: invert; outline-style: none; outline-width: 0px; vertical-align: baseline; padding: 0px; margin: 0px 0px 3.84px 0px; border: 0px none #4d4d4d;"> </DIV><DIV style="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 12.8px; max-height: 500px; outline-color: invert; outline-style: none; outline-width: 0px; overflow: auto; vertical-align: baseline; padding: 0px; margin: 0px 0px 3.84px 0px; border: 0px none #4d4d4d;"><PRE style="background-color: #eeeeee; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 14.06px; line-height: 16.88px; outline-color: invert; outline-style: none; outline-width: 0px; overflow-x: auto; overflow-y: hidden; vertical-align: baseline; width: 1439.25px; padding: 10px 10px 25px 10px; margin: 0px 0px 0px 15px; border: 1px dashed #c2c4ba;"><CODE style="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 14.06px; outline-color: invert; outline-style: none; outline-width: 0px; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px none #4d4d4d;">Expression: string.capwords(!STATE_NAME!, ' ')&nbsp; Expression Type: PYTHON_9.3&nbsp; Code Block: import string</CODE></PRE></DIV></DIV><DIV style="background-color: transparent; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; color: #4d4d4d; font-family: Arial,Helvetica,sans-serif; font-size: 12.8px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; outline-color: invert; outline-style: none; outline-width: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; vertical-align: baseline; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; padding: 0px; margin: 0px 0px 3.84px 0px; border: 0px none #4d4d4d;"><DIV style="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 12.8px; outline-color: invert; outline-style: none; outline-width: 0px; vertical-align: baseline; padding: 0px; margin: 0px 0px 3.84px 0px; border: 0px none #4d4d4d;"> </DIV><DIV style="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 12.8px; max-height: 500px; outline-color: invert; outline-style: none; outline-width: 0px; overflow: auto; vertical-align: baseline; padding: 0px; margin: 0px 0px 3.84px 0px; border: 0px none #4d4d4d;"><PRE style="background-color: #eeeeee; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 14.06px; line-height: 16.88px; outline-color: invert; outline-style: none; outline-width: 0px; overflow-x: auto; overflow-y: hidden; vertical-align: baseline; width: 1439.25px; padding: 10px 10px 25px 10px; margin: 0px 0px 0px 15px; border: 1px dashed #c2c4ba;"><CODE style="border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; font-size: 14.06px; outline-color: invert; outline-style: none; outline-width: 0px; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px none #4d4d4d;">Expression: MySub(!STATE_NAME!)&nbsp; Expression Type: PYTHON_9.3&nbsp; Code Block: def MySub(myfieldname):&nbsp; import string&nbsp;&nbsp; return string.capwords(myfieldname, ' ')</CODE></PRE></DIV></DIV></BODY></HTML> Thu, 17 Jan 2019 18:40:45 GMT https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486243#M1492 JayJohnson2 2019-01-17T18:40:45Z Re: how to change a field to proper case https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486244#M1493 <HTML><HEAD></HEAD><BODY><P><A class="link-titled" href="http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000004s000000" title="http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000004s000000">ArcGIS Help 10.1</A>&nbsp;</P></BODY></HTML> Thu, 17 Jan 2019 18:41:06 GMT https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486244#M1493 JayJohnson2 2019-01-17T18:41:06Z Re: how to change a field to proper case https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486245#M1494 <HTML><HEAD></HEAD><BODY><P>ArcGIS Pro:</P><P></P><P><A class="link-titled" href="http://pro.arcgis.com/en/pro-app/tool-reference/data-management/calculate-field-examples.htm" title="http://pro.arcgis.com/en/pro-app/tool-reference/data-management/calculate-field-examples.htm">Calculate Field Python examples—Data Management toolbox | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Thu, 17 Jan 2019 18:43:05 GMT https://community.esri.com/t5/java-maps-sdk-questions/how-to-change-a-field-to-proper-case/m-p/486245#M1494 JayJohnson2 2019-01-17T18:43:05Z