This content has been marked as final. Show 6 replies
I would like to import postcode field in a table but only import the first section of the UK postcode.
UK postcodes begin with either 1 or two letters, have a single or double digit number and then end with a number and 2 letters. E.g:
LN NLL or LLN NLL or LLNN NLL or LNN NLL (they won't always have a space between).
I'm only interested in inputting the first characters (everything before the last 3 digits - LN, LLN, LLNN, LNN).
Is there a way of doing this as a calculated field when loading a table?