Parse State from Address String

[Piper]

I am working to extract the state from an address string.  I have extracted the zip code from the end of the string, but need help with parsing the state.  I realize my results may not be 100%, but would like it to be close. 

Sample data below:  

.

DELRAY BEACH FL 33446

RIDGWAY CO 81432

DENVER CO 80221

Lxxxx   xx xxxxxxx 11111 xx 11yy yy xxxxxxx FL 33322 6977

[atcodedog05]

Hi @Piper 

Can you give us a expected output. So that we can build accordingly.

[atcodedog05 · Accepted solution]

Hi @Piper 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @Piper 

Cheers and Happy Analyzing 😀