3 Replies Latest reply: Oct 10, 2015 6:35 AM by Marco Wedel RSS

    UK Postcode Formatting

      Hi,

       

      I hope someone is able to help me with my query.

       

      I have a large amount of data I need to feed into Qlikview and i'm having issues formatting the Postcode field.  What I need is to convert a full postcode into a 5 character code.  As UK postcodes come in all different shapes and sizes this is proving to be a little bit trickier than I first envisaged.

       

      I'll try and show examples of what i'm looking for below.

       

      Original Postcode          5 Character Version (The format I need)

      LL32 8AJ                        LL328

      BB7 3ER                        BB7 3 (Includes 1 space)

      L1 8EE                           L1  8 (Includes 2 spaces)

      IP12 2UE                       IP122

      W1W 5NU                     W1W 5 (Includes 1 space)

       

      I hope this gives a good idea of exactly what i'm after?

       

      Cheers,

       

      Paul