I’m setting up a logic sequence that takes any UK postcode and removes the final 3 characters and returns the remaining characters.
e.g.
B48OP becomes B4
B755UG becomes B75
and WV125ET becomes WV12
The postcode string could be 5, 6 or 7 characters long - in each case I want to remove the final 3 characters and return the remaining characters as above. I’ve already created steps to remove spaces and make upper case - it’s just this final bit I can’t figure out.
Any ideas?