353
edits
Changes
Jump to navigation
Jump to search
Select distinct * Feature city records and store them is in table citylist2. SQL Code: SELECT city FROM ptoassigneend_us_temp WHERE city IN ( SELECT citylist (30971 FROM citylist2). -- SELECT 2574811 !!! SELECT 847
-- 565
Patent Assignment Data Restructure (view source)
Revision as of 15:55, 20 April 2017
, 15:55, 20 April 2017→Clean Feature City
===== Clean Feature City =====
Select distinct city records and store them in table citylist (30971).
Select distinct city records in ptoassigneend_us_extracted and store them in citylist2 (775).
The following patterns can be used to clean feature city.
* city, state postcode(5)
'.*[,].*\d{5}'
* city, state code
