AnsweredAssumed Answered

Deleting last 3 characters using field calculator in ArcGIS Pro (UK Postcode)

Question asked by emily.catt on Jul 9, 2019
Latest reply on Jul 9, 2019 by bixb0012

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 

 

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!

 

Would appreciate any help with this

Outcomes