353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:00, 16 March 2017
, 17:00, 16 March 2017→Restructure Address Information
===Restructure Address Information===
SQL code and other things are in: E:/McNair/Projects/PatentAddress Notes:*The addrline1 and addrline2 columns include post code, city and state information while the state, post code and country columns may have missing values. *Besides, some city records also include post code and country information.
The basic idea to extract information from addrline1 and addrline2 is to search for post code following a specific pattern using regular expression. The state information is always ahead of post code.
