353
edits
Changes
Jump to navigation
Jump to search
SQL code: WHEN addrline1 ~* 'CORPThis pattern is not reliable.*OF(\s|$)' LTRIM(RTRIM(SUBSTRING(regexp_replace(SUBSTRING(When addrline1looks this way, 'CORPaddrline2 always provide more detailed address information than addrline2.*OF.*')Besides,the state extracted from 'A CORP.*OF[State]', doesn'')t match the state extracted from detailed addrline2. In this way,1,18)))we discarded this pattern.
A CORPORATION OF NY
A CORPORATION OF TEXAS
A CORPORATION OF NEW YORK
A CORP. OF INDIANA
A CORP. OF OR
A CORPORATION OF IL P.O. BOX 5018
CORPORATE SECRETARY'S OFFICE
A CORP. OF NEW YORK
A CORP. OF OHIO
A CORP. OF CA.
A CORP. OF DE.
Noise exists: ( A CORP. OF NEW YORK | ONE LINCOLN FIRST SQUARE, ROCHESTER, NEW YORK, NY 14601-0054 A CORPORATION OF NY | 550 MADISON AVENUE, NEW YORK, NY 10022-3201 A NON-PROFIT CORP. OF WASHINGTON | 4225 ROOSEVELT WAY NE, STE. 303 SEATTLE, WA 98105-6099 A CORP. OF MN | 2611 NORTH SECOND ST., MINNEAPOLIS, MN 55411-1633 A CORPORATION OF DE | 612 WHEELER'DELAWARES FARM RD. MILFORD, CT 06460-8719 A CORP. OF WA. | 411 FIRST AVENUE SOUTH SEATTLE, WASHINGTON 98104-2871 A CORPORATION OF OREGON | ONE BOWERMAN DRIVE, BEAVERTON, OREGON 97005-6453 A CORPORATION OF | ONE BOWERMAN DRIVE BEAVERTON, OR 97005-6453 A CORP. OF INDIANA | 4810 TECUMSEH LANE, POST OFFICE BOX 15190 EVANSVILLE, INDIANA 47716-0190 A CORPORATION OF PA | 7200 SUTER ROAD, COOPERSBURG, PA 18036-1299 A CORP. OF DE | SCARBORO & BEAR CREEK ROAD, P.O. BOX 2009 OAK RIDGE, TENNESSEE 37831-8014 If you' and re interested, the SQL code is WHEN addrline1 ~* 'CA' both existCORP.*OF(\s|$)' 2200 MISSION COLLEGE BOULEVARD SANTA CLARATHEN LTRIM(RTRIM(SUBSTRING(regexp_replace(SUBSTRING(addrline1, CA 95052-8119 A 'CORP.*OF.*'),'CORP. *OF DELAWARE ', ''), 1, 18))) * Summary
Patent Assignment Data Restructure (view source)
Revision as of 14:56, 5 April 2017
, 14:56, 5 April 2017→3. State (U.S.)
'''d. 'A CORP.* OF [State]''''
Examples:
The extracted state records are stored in the table ptoassigneend_missus_final.
