353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:17, 13 April 2017
, 17:17, 13 April 2017→Postcode(U.S.)
=====Postcode(U.S.)=====
U.S. postcode follows the pattern [five digits - four digits]. In this way, U.S. patents can be extracted by searching for post code postcode with regular expression
'(^|\s)\d{5}-\d{4}($|\s)'
OXFORD CT 06483-1011 | 06483-1011
The extracted post code records are stored postcode is in table ptoassigneend_us_extracted.
SQL code is in:
