Changes

Jump to navigation Jump to search

Patent Assignment Data Restructure (view source)

Revision as of 15:52, 3 April 2017

11 bytes added ,  15:52, 3 April 2017
→‎3. State (U.S.)
SQL code:
WHEN addrline1 ~* 'CORP.*OF(\s|$)'
THEN LTRIM(RTRIM(SUBSTRING(regexp_replace(SUBSTRING(addrline1, 'CORP.*OF.*'),'CORP.*OF', ''),1,18)))
Examples:
Retrieved from "http://www.edegan.com/wiki/Special:MobileDiff/17286"

Navigation menu