I have a string that looks like this:

Company|Address|City State Zip|other info


I need to split the City State and Zip into seperate fields using "|"

The state is always 2 letters
City is not always one word


How can I do this?
Thanks