353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:31, 21 March 2017
, 16:31, 21 March 2017→Restructure Address Information
:: There are some patterns that can be used to extract city information.
::* \s{2,} CITY NAME, STATE POSTCODEaddrline1
::::*'\s{2,} CITY NAME, STATE POSTCODE' ::::For example,
SANTA CLARA, CA 95054-1537
PITTSBURGH, PA 15230-0250
::::Noise:
800 NORTH QUINCY STREETARLINGTON, VA 22217-5660 (street name instead of city name)
BATON, ROUGE, LA 70809-4562 (the city name is separated by a comma)
ST. PAUL, MIN 55133-3427 (special)
:: A list * addrline2 ::::* '[,]\s{1,} CITY NAME[,] STATE POSTCODE' :: Three lists of samples extracted from addrline1 , addrline2 and city are used to summarize the patterns. The samples are in Z:/PatentAddress/citysample.txt
:'''5. Issues'''
