Hello! Having some trouble finding out a way to extract any 2 letter state abbreviations from a string. Most of what I've googled returns pull state values from a address, but in my data, its more like random sentences and words.
-if multiple states found, they will need to be separated by a comma
-the state will always be capitalized in the string (eg. FL, TX, MO)
-in some tricky instances like "(CALIFORNIA and TEXAS and CO)", only the state value "CO" will be pulled since California and Texas are not in the abbreviated form
Much apprevaited!
-if multiple states found, they will need to be separated by a comma
-the state will always be capitalized in the string (eg. FL, TX, MO)
-in some tricky instances like "(CALIFORNIA and TEXAS and CO)", only the state value "CO" will be pulled since California and Texas are not in the abbreviated form
Much apprevaited!
today is the day in CA where the sun sets | CA |
DE is quite far from FL | DE, FL |
NY | NY |
(CALIFORNIA and TEXAS and CO) | CO |