2 Replies Latest reply: May 17, 2011 9:40 AM by Paul Nockolds RSS

    Splitting UK Postcodes

    Paul Nockolds

      Hello

       

      Using QV10

       

      I have a spreadsheet with a UK postcodes column in it...

      FullPostcodes.jpg

       

      I have another spreadsheet that looks like this...

      Postcodes.jpg

       

      I want to be able to match the 2 together based on the first 1 or 2 letters in the postcode so i can then filter my data by Post Town or Region.

       

       

      How can i obtain the first 1 or 2 letters from my list of full postcodes?

       

      I am thinking i will need to check for an ASCII number to determine if i need just the first letter or the first 2 but i am sure there is a better alternative!?  PurgeChar looks interesting, perhaps i can use subfield to grab the first part of the postcode and purgechar to remove the number part(s) - (thinking as i'm writing here).

       

      Any ideas?  Is there a better solution?

       

      thanks

      Paul