6 Replies Latest reply: May 10, 2016 10:05 AM by Sunny Talwar RSS

    Remove last 3 digits from UK postcode

      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?