353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 14:38, 27 March 2017
, 14:38, 27 March 2017→Restructure Address Information
:: 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}'
