353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:10, 16 March 2017
, 17:10, 16 March 2017→Restructure Address Information
Methods:
*The basic idea is to find Postcode Extraction U.S. post code follows the pattern [five digits] or [five digits - four digits]. U.S. patents can be extracted by searching for post code following a specific pattern these patterns using regular expression. The state information is always ahead of Some other countries also use [five digits] for post code, so only post codes following [five digits - four digits] are extracted. SQL code are in: E:/McNair/Projects/PatentAddress/
U.S. postcode is like [five digits - four digits]. In this way, I created a table named 'ptoassigneend_missus' to store records containing [five digits - four digits]. Then, using the method above to extract useful address information.
