I need to extract the state code from the following examples.
MYstring.USA.TX.123332.QA => return TX
ABESC.TUNUE.TX.AFEEDGF.BEDS = Return TX
The State code will always start after the second occurrence of a period "." But its position in the string can change.
So i think i need to be able to return the position of the 2nd and 3rd period then with that maybe us MID to extract it.
How do i get the position of those two periods?
Is there a better way? Maybe SPLIT into array and grab the 3rd value? I will need other pieces of this string extracted.