This question already has an answer here:
I wonder how to delete a word (or the last 5 characters) using the field calculator in ArcGIS 10.2. I have a column such as:
Paris City; London City; Berlin City
I need to remove "City", to be left with Paris, London, Berlin.
Any tips on doing this automatically?