353
edits
Changes
Jump to navigation
Jump to search
::The issue is that both abbreviation and state name exist.
Patent Assignment Data Restructure (view source)
Revision as of 16:26, 20 March 2017
, 16:26, 20 March 2017no edit summary
::The state and post code are always together, separated by a space. So we can also extract state information with regular expression too.
::The extracted state records are stored in table ptoassigneend_missus_final.
::* Some state and country features don't match. For example, 'Beijing' - 'UNITED STATES, 10022'.
::* Both state name and its abbreviation exist.
