Standard spreadsheet functions can be used to change all letters to upper case, to search for spaces, check for simple substitutions and to pad or condense the postcode to a desired length. It is possible for the research user to employ simple tools to overcome some of the most commonly encountered problems before attempting to process their postcodes. Tottenham Court Road Tube Station, London Royal Mail Central Birmingham Delivery Officeĭriver and Vehicle Licensing Authority, Swansea Where " A" represents an alphabetic character, " N" represents a number and " _" represents a space, valid postcodes will always follow one of the following patterns: Pattern
#Postal code for surrey uk manual#
If the user has a moderate level of confidence that a postcode list is already likely to be of reasonable quality and consistently formatted, it can be easiest to proceed with processing using software such as GeoConvert and then to attempt manual correction or removal of any postcodes which fail to be matched. UK Postcode Patterns and Conversion Algorithms It is unlikely that the research user who does not have a repeated need to match large postcode lists will wish to become involved in this level of checking, which will also necessitate programming skills. The detailed rules for determining whether a UK postcode is valid are complex and require a checklist of all the characters which are valid in each position of the code. These types of error occur most frequently when the original data were entered by hand and have not been subsequently cleaned or validated.įor those with large quantities of data to process, there is a range of commercial services on offer whereby computer-readable postcode lists can be cleaned and correctly formatted using specialist software - this is primarily intended for those preparing large mailshots. They illustrate problems of incorrect spacing, inconsistent letter case ("J" and "j") and substitution of similar characters ("I" and "1", "O" and "0").
However, none of them is technically correct and none would automatically match the correct version using general purpose office or statistical software. The following are all variants of the same postcode which are close enough to the correct version that they would probably be correctly delivered by the postal service.
Both seven and eight character versions are widely used.
"SO171BJ" is a variant of this code which is technically correct but which contains only seven characters, with no space. It contains eight characters altogether, one of which is a space separating the incode ("SO17")and outcode ("1BJ") parts. "SO17 1BJ" is a full, correct, unit postcode. Unfortunately there are multiple ways of writing postcodes in common usage, including several common errors, which are readily interpretable to the human eye but which will cause automated matching of postcodes to fail. Most computer applications which use postcodes will require the codes to be formatted in a particular way in order to operate correctly.
0 kommentar(er)
