Changes

Patent Assignment Data Restructure (view source)

16 bytes removed , 15:38, 27 March 2017

:: There are some patterns that can be used to extract state information.

::*'~~CITY NAME~~[,] STATE POSTCODE'

:::The state and post code are always together, separated by a space. So we can also extract state information with regular expression

BROOKINGS, SOUTH DAKOTA 57006-0128 | SOUTH DAKOTA

::*'~~CITY NAME~~ \s STATE(Abbreviation) POSTCODE'

'(^|\s)\w{2}\s{1}\d{5}[-]\d{4}'

353

edits