Changes

Patent Assignment Data Restructure (view source)

18 bytes removed , 12:29, 2 May 2017

==== Output: ptoassigneend_us_identify2 ====

Part of 'city' contains ~~punctuation~~comma. Remove ~~punctuation marks~~comma, and then match 'city' with ptoassigneend_us_citylist.

SELECT *, replace(city, ',', '') clean_city

353

edits