353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:25, 30 March 2017
, 16:25, 30 March 2017→3. State (U.S.)
SQL code:
WHEN addrline1 ~* 'CORP.*OF(\s|$)' THEN LTRIM(RTRIM(regexp_replace(SUBSTRING(addrline1, 'CORP.*OF.*'),'CORP.*OF', '')))
Examples:
