Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 5 of 5

UK Postcodes

This is a discussion on UK Postcodes within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi Can anyone advise what format a UK postcode should be in for import into Mappoint ? I have a ...

  1. #1
    Marktl is offline Junior Member White Belt
    Join Date
    Dec 2008
    Posts
    1

    UK Postcodes

    Hi

    Can anyone advise what format a UK postcode should be in for import into Mappoint ? I have a two column dataset with a postcode in column A and the description in Column B and want to plot the 42 locations onto mappoint but it falls over when I try and do the import.

    Any ideas gratefully received !"

    Thanks

    Mark

  2. #2
    John.Sewell is offline Member Yellow Belt
    Join Date
    Oct 2007
    Posts
    42

    Re: UK Postcodes

    You may have another problem, I have found Mappoint pretty tolerant and 'intelligent' in interpreting a variety of Postcode formats. However, it can get confused if there is no space so you may solve your problem by making sure you have (for instance) SN11 4DF, rather than SN114DF.

  3. #3
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: UK Postcodes

    Quote Originally Posted by Marktl View Post

    want to plot the 42 locations onto mappoint but it falls over when I try and do the import.

    Any chance of seeing some examples Mark??
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  4. #4
    PeterLeeds is offline Junior Member Yellow Belt
    Join Date
    Aug 2007
    Posts
    15

    Re: UK Postcodes

    Quote Originally Posted by Marktl View Post
    Hi

    Can anyone advise what format a UK postcode should be in for import into Mappoint ? I have a two column dataset with a postcode in column A and the description in Column B and want to plot the 42 locations onto mappoint but it falls over when I try and do the import.

    Any ideas gratefully received !"

    Thanks

    Mark
    http://www.govtalk.gov.uk/gdsc/html/noframes/PostCode-2-1-Release.htm

    The one constant is the last 3 characters.
    To make sure there is always a space use something like:-
    MS-Access VBA
    postcode = Replace(postcode, " ", "") 'Remove all spaces
    postcode = Left$(postcode, Len(postcode) - 3) & " " & Right$(postcode, 3) ' Add space in correc position
    postcode = StrConv(postcode, vbUpperCase) 'Convert to Upper Case

    Possibly more than you asked for but what the hell

    Regards

    Peter

  5. #5
    Quin is offline Junior Member White Belt
    Join Date
    Oct 2006
    Posts
    8

    Re: UK Postcodes

    Hi Mark,
    This document ( GDSC - Postcode ) gives a pretty good illustration of how postcodes should look. I've used it as a guide for constructing several MP applications that require a full set of UK postcodes, and have the ability to check that a postcode that the user types is properly formatted.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. postcodes
    By Tomm in forum MapPoint Desktop Discussion
    Replies: 8
    Last Post: 08-22-2008, 06:46 AM
  2. UK postcodes not fully
    By salih.canoz in forum Bing Maps and MapPoint Web Service
    Replies: 0
    Last Post: 10-17-2007, 03:54 AM
  3. Riute between Postcodes using VB.net
    By Enigma in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-07-2007, 01:49 PM
  4. Updating UK Postcodes
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-28-2003, 01:39 PM
  5. Postcodes mapping
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-06-2002, 10:20 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127