353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:34, 28 April 2017
, 16:34, 28 April 2017→Clean Postcode
====Clean Postcode====
Identifying five-digit postcode is risky because of the existence of P.O. BOX # and , SUITE #, etc. One option is to identify state and postcode together with the following SQL code: (take 'addrline1' as an example)
SELECT
