::The state and post code are always together, separated by a space. So we can also extract state information with regular expression too.
::For example, city | state_city
NEW YORK, NY 10022-3201 | NY
BEAVERTON, OREGON 97005-6453 | OREGON
SANTA BARBARA, CA 93130-3003 | CA
SUNNYVALE, CA 94088-3453 | CA
NEW YORK, NY 10013-2412 | NY
OALKLAND, CA 94612-3550 | CA
SANTA CLARA, CA 95052-8090 | CA
PEORIA, IL 61629-6490 | IL
MIDVALE, UTAH 84047-1408 | UTAH
OAKLAND, CA 94612-3550 | CA
HARRISBURG, PA 17105-3608 | PA
ROCHESTER, NY 14650-2201 | NY
NEW YORK, NY 10013-2412 | NY
HOUSTON, TEXAS 77256-6571 | TEXAS
BROOKINGS, SOUTH DAKOTA 57006-0128 | SOUTH DAKOTA
::The extracted state records are stored in table ptoassigneend_missus_final.