353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:43, 3 April 2017
, 16:43, 3 April 2017→Master Table
c. Postcode is the priority
postcode_city is the postcode extracted from 'city'; postcode_addr1 is the postcode extracted from 'addrline1'; postcode_addr2 is the postcode extracted from 'addrline2'.
Fortunately, the postcode_city, postcode_addr1, postcode_addr2 and postcode are consistent except a few records:
reelno | frameno | postcode | postcode_addr1 | postcode_addr2 | postcode_city | postcode_new
12361 | 456 | 78759 | | | 11788-8847 | 78759
====Issues====
