UK Users Group


  • 1.  code-point-open-user-guide

    Posted 01-30-2018 15:03
      |   view attached

    Establish a single space in the OS Code-Point Open data for postcodes

    Ordnance Survey supply the postcode data as csv files but the postcode field is set to 7 characters with 2, 1 or zero spaces between the in and out codes. Refer to page 15 of the attached User Guide on how to update this format to a single space postcode.

    Most importanly, make sure your new field is a width of '8'.

    The expression is:

    RTrim$(Left$(Postcode,(Len(Postcode)-3))) + " " + Right$(Postcode,3)