353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:09, 27 April 2017
, 17:09, 27 April 2017→Clean Address: more patterns
WHERE city ~* '[,]\s{1,}\w{2}' OR city ~* '[,]\s{1,}\w{1}[.]\w{1}[.]'
;
#SELECT 1291254
*Pattern 3: 'city' is like 'city name, state postcode (5 digits)'
