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

    Splitting UK Postcodes

    Paul Nockolds



      Using QV10


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



      I have another spreadsheet that looks like this...



      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?