topic Re: Deleting last 3 characters using field calculator in ArcGIS Pro (UK Postcode) in Python Questions https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306114#M23747 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.esri.com/migrated-users/3420">Joshua Bixby</A>,</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>Joshua Bixby markeerde het antwoord van Emily Catt als juist</P></BLOCKQUOTE><P>Why did you mark the "Thank you" as the correct answer, and not the actual answer I gave to the question?</P><P></P><P>Just curious <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Egge-Jan</P></BODY></HTML> Tue, 09 Jul 2019 21:13:31 GMT Egge-Jan_Pollé 2019-07-09T21:13:31Z Deleting last 3 characters using field calculator in ArcGIS Pro (UK Postcode) https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306110#M23743 <HTML><HEAD></HEAD><BODY><P>I have no idea how to use Python but I'm pretty sure there would be a way to do this, it's like using the MID query in excel. I'm using ArcGIS Pro and have a field for UK Postcodes, either in the format E4 9SU, DA12 7JS or DA1 7JS. I am trying to use the Field Calculator to delete the last three characters (4 including the space) so I will be left with either E4, DA12 or DA1&nbsp;</P><P></P><P>Is anyone able to help in writing the script? as I wouldn't even know where to start. The input field is called Match_Addr so after some research I'm assuming the input would be !Match_addr!</P><P></P><P>Would appreciate any help with this</P></BODY></HTML> Tue, 09 Jul 2019 14:12:16 GMT https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306110#M23743 e_cat 2019-07-09T14:12:16Z Re: Deleting last 3 characters using field calculator in ArcGIS Pro (UK Postcode) https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306111#M23744 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.esri.com/migrated-users/347248">Emily Catt</A>,</P><P></P><P>As you can see in the screen capture below I did take the content of the field POSTCODE to populate the field POSTCODE_SHORT with only the first part of the postal code.</P><P></P><P>Using <STRONG>Calculate Field</STRONG>, the very pythonic syntax to accomplish this is:</P><P><SPAN style="font-family: courier new, courier, monospace;">''.join(!POSTCODE!.split())[:-3]</SPAN></P><P></P><P>So in your case that would be:</P><P><SPAN style="font-family: courier new, courier, monospace;">''.join(!Match_addr!.split())[:-3]</SPAN></P><P></P><P>Please refer to this discussion for additional explanation: <A class="link-titled" href="https://stackoverflow.com/questions/1798465/python-remove-last-3-characters-of-a-string" title="https://stackoverflow.com/questions/1798465/python-remove-last-3-characters-of-a-string">Python Remove last 3 characters of a string - Stack Overflow</A>&nbsp;</P><P></P><P>Hope this helps,</P><P></P><P>Egge-Jan</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/452648_pastedImage_1.png" /></P></BODY></HTML> Tue, 09 Jul 2019 14:50:07 GMT https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306111#M23744 Egge-Jan_Pollé 2019-07-09T14:50:07Z Re: Deleting last 3 characters using field calculator in ArcGIS Pro (UK Postcode) https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306112#M23745 <HTML><HEAD></HEAD><BODY><P>Thank you for your speedy response Egge-Jan, worked like a charm! Thank you <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 09 Jul 2019 15:11:41 GMT https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306112#M23745 e_cat 2019-07-09T15:11:41Z Re: Deleting last 3 characters using field calculator in ArcGIS Pro (UK Postcode) https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306113#M23746 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.esri.com/migrated-users/347248">Emily Catt</A>,</P><P></P><P>Sounds like your issue has been solved, doesn't it?</P><P></P><P>Would you please be so kind to mark your question as being answered? This will help the community in finding correct information.</P><P></P><P>Cheers,</P><P></P><P>Egge-Jan</P></BODY></HTML> Tue, 09 Jul 2019 15:25:10 GMT https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306113#M23746 Egge-Jan_Pollé 2019-07-09T15:25:10Z Re: Deleting last 3 characters using field calculator in ArcGIS Pro (UK Postcode) https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306114#M23747 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.esri.com/migrated-users/3420">Joshua Bixby</A>,</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>Joshua Bixby markeerde het antwoord van Emily Catt als juist</P></BLOCKQUOTE><P>Why did you mark the "Thank you" as the correct answer, and not the actual answer I gave to the question?</P><P></P><P>Just curious <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Egge-Jan</P></BODY></HTML> Tue, 09 Jul 2019 21:13:31 GMT https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306114#M23747 Egge-Jan_Pollé 2019-07-09T21:13:31Z Re: Deleting last 3 characters using field calculator in ArcGIS Pro (UK Postcode) https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306115#M23748 <HTML><HEAD></HEAD><BODY><P>Sorry about that, clicked on the wrong link.&nbsp; I just updated it.</P></BODY></HTML> Tue, 09 Jul 2019 22:26:31 GMT https://community.esri.com/t5/python-questions/deleting-last-3-characters-using-field-calculator/m-p/306115#M23748 JoshuaBixby 2019-07-09T22:26:31Z