Forum Discussion

JonathanHeuer's avatar
JonathanHeuer
Qrew Cadet
11 years ago

Converting state address field into two letter abbreviation

The state address field displays the full name of the state. I would like to get the two letter abbreviation (i.e. "MI" instead of "Michigan"). Besides creating my own lookup table, is there another ...
Tables and fields
JohnBrindamour's avatar
JohnBrindamour
Qrew Member
8 years ago
Thanks guys, very helpful. I ended up converting the state/region to upper and used Contains within an IF. Maybe that's possible with Case but I couldn't seem to get it to work.

If (
Contains(Upper([Ship To: State/Region]),"ALABAMA"), "AL",
Contains(Upper([Ship To: State/Region]),"ALASKA"), "AK",
Contains(Upper([Ship To: State/Region]),"ARIZONA"), "AZ",
Contains(Upper([Ship To: State/Region]),"ARKANSAS"), "AR",.........etc.