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

    Remove last 3 digits from UK postcode

    Simon Hynd

      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?