Requirement below then requires option to reverse the process.
Module required to convert postcode from list form to condensed short form. So 2 tables.
1. Postcode Gazetter 2015
2. Postcode UK Pricebooks
We need to create the table as a make table query in Postcode UK Pricebooks from the data in Postcode Gazetter 2015. It needs to follow a strict format.
So 79 records for B Postcode which all go into Zone 1 so will display simply as B it will then break with a , and the " " and then display the next alphabetic record which is BB and so on.
When the postcode appears in 2 zones eg. BD it needs to be broken and display the postcode district numbers so BD1-22,97,99, then space then BL. The remainder of BD that cross refers to BD will be in zone 2.
Zone 1 - B, BB, BD1-22,97-99, BL, CH, CV, CW, DE, DN1-12,16-17,21-22,31-35,40-41,55, DY, GL1-4,7,14,
Zone 2 - BD23-24,
Ultimately the table will looks as per Postcode UK Pricebooks but created from a make table query from Postcode Gazetter 2015.