353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:20, 1 May 2017
, 16:20, 1 May 2017→Clean city
#SELECT 1254
*Pattern 32: 'city' is like 'city name, state postcode (5 digits)'
Extract city and state info with SQL code:
-- SELECT 51050
*Pattern 3: 'city' is like 'city name,'
Replace(city, ',','')
The SQL function is in
