I would like to locate/organize my valid agency IDs (agencyid).
agencyid
CA0006
TN0106
NY0009
LA0035
TN0105
TN01o
CA0017
cA0006
La0035
The correct structure of the agency ID should be the state letters = 4 numbers ex,. (NY1111)The first thing I wanted to do is to make the first two letter of...