Splitting UK Postcodes

[haymarketpaul]

Hello

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?

thanks

Paul

[#2]

Hi Paul,

Have you tried using the left(fieldname,count) string function and link this to your look-up table?

Cheers,

Shyam

[haymarketpaul · Accepted solution]

Thanks for the reply.  The problem i could see with Left was how to determine whether i needed only the first (Count=1) character or the first 2 (Count=2).

I used this in the end...

PurgeChar(Left(Postcode,2),'1234567890')