353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:01, 27 April 2017
, 17:01, 27 April 2017→Clean Address: more patterns
REPLACE(SUBSTRING(city, '[,].*'),',','') state_candid
FROM ptoassigneend_us_temp3
WHERE city ~* '[,]\s{1,}\w{2}' OR city ~* '[,]\s{1,}\w{1}[.]\w{1}[.]'
;
#SELECT 129
