topic Re: ArcGIS Pro 1.4 Field calculator in Data Management Questions https://community.esri.com/t5/data-management-questions/arcgis-pro-1-4-field-calculator/m-p/130783#M7534 <HTML><HEAD></HEAD><BODY><P>Use this python expression:</P><P><STRONG><SPAN class="">!fieldname![0]</SPAN></STRONG></P></BODY></HTML> Mon, 10 Apr 2017 06:41:37 GMT JayantaPoddar 2017-04-10T06:41:37Z ArcGIS Pro 1.4 Field calculator https://community.esri.com/t5/data-management-questions/arcgis-pro-1-4-field-calculator/m-p/130782#M7533 <HTML><HEAD></HEAD><BODY><P>how do i extract the first character from another field, In desktop i would of used the Left([Field1],1)</P></BODY></HTML> Mon, 10 Apr 2017 03:45:35 GMT https://community.esri.com/t5/data-management-questions/arcgis-pro-1-4-field-calculator/m-p/130782#M7533 MatthewIrwin 2017-04-10T03:45:35Z Re: ArcGIS Pro 1.4 Field calculator https://community.esri.com/t5/data-management-questions/arcgis-pro-1-4-field-calculator/m-p/130783#M7534 <HTML><HEAD></HEAD><BODY><P>Use this python expression:</P><P><STRONG><SPAN class="">!fieldname![0]</SPAN></STRONG></P></BODY></HTML> Mon, 10 Apr 2017 06:41:37 GMT https://community.esri.com/t5/data-management-questions/arcgis-pro-1-4-field-calculator/m-p/130783#M7534 JayantaPoddar 2017-04-10T06:41:37Z Re: ArcGIS Pro 1.4 Field calculator https://community.esri.com/t5/data-management-questions/arcgis-pro-1-4-field-calculator/m-p/130784#M7535 <HTML><HEAD></HEAD><BODY><P>But if there is the remotest change that you will have nulls in your table, then you have to go with a bit more pythonic magic which basically does a true/false test.&nbsp; if the field called 'afield' is None (aka Null) then you take the slice to the right of the selection options.&nbsp; If it contains text, then you take the slice to the left, which is the false part.</P><P>So in short the syntax is [ false section, true section][query]&nbsp;&nbsp; or [0, 1][query] [False, True][query] useful functionality avoiding code blocks for simple yes/no questions</P><PRE class="language-python line-numbers"><CODE><SPAN class="punctuation token">[</SPAN>!afield!<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>!afield! <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 10 Apr 2017 06:56:52 GMT https://community.esri.com/t5/data-management-questions/arcgis-pro-1-4-field-calculator/m-p/130784#M7535 DanPatterson_Retired 2017-04-10T06:56:52Z Re: ArcGIS Pro 1.4 Field calculator https://community.esri.com/t5/data-management-questions/arcgis-pro-1-4-field-calculator/m-p/130785#M7536 <HTML><HEAD></HEAD><BODY><P>You can also handle the None/NULL issue using a Python conditional expression, which avoids the need for a code block with simple expressions and follows a classic ternary operator pattern:</P><PRE class="language-python line-numbers"><CODE>None <SPAN class="keyword token">if</SPAN> None <SPAN class="keyword token">else</SPAN> !Field1!<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 10 Apr 2017 13:42:32 GMT https://community.esri.com/t5/data-management-questions/arcgis-pro-1-4-field-calculator/m-p/130785#M7536 JoshuaBixby 2017-04-10T13:42:32Z