353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:33, 10 March 2017
, 17:33, 10 March 2017no edit summary
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.
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.
The SQL code is as follows:
