Changes

Jump to navigation Jump to search
===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.

Navigation menu