353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:15, 29 March 2017
, 16:15, 29 March 2017→Restructure Address Information
MASSACHUSETTS 02780-7319 ('State Postcode')
'''*Other Noise: g. Special cases''' Examples: BATON, ROUGE, LA 70809-4562 (the city name 'BATON ROUGH' is separated by a comma) ST. PAUL, MIN 55133-3427 (city name 'ST. PAUL' contains a dot)
QUINCY STREETARLINGTON, VA 22217-5660 (no space between street and city name :(
SQL code:
CASE WHEN addrline1 ~* 'BATON[,] ROUGE[,]\s{1}LA'
THEN 'BATON ROUGE'
WHEN addrline1 ~* 'ST[.]\s{1}PAUL'
THEN 'ST. PAUL'
WHEN addrline1 ~* 'ARLINGTON[,]\s{1}VA'
THEN 'ARLINGTON'
'''Noise: '''
BOX 87703CHICAGO, IL 60680-0703 (no space between street and city name :(
