353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:10, 21 March 2017
, 16:10, 21 March 2017→Restructure Address Information
:'''4. City (U.S.)'''
:: There are some patterns that can be used to extract city information. ::* \s{2,} CITY NAME, STATE POSTCODE ::For example, SANTA CLARA, CA 95054-1537 PITTSBURGH, PA 15230-0250 ::Noises, 800 NORTH QUINCY STREETARLINGTON, VA 22217-5660 BATON, ROUGE, LA 70809-4562 (the city name is separated by a comma) They are in:
E:/McNair/Projects/PatentAddress/City_Patterns.sql
