Best way to swap a list of values
Hi. I am using ziptastic.com to look up and autofill city and state fields on an address form based on zip code. However the site returns the state's full name instead of the 2-letter code ("California" instead of "CA"). What is the cleanest way to convert the long names back to short ones?
1) In my script step, when I set the state field, go through a (very long) series of nested if "long name" then "short name" statements?
2) Create a State table and do a lookup from there?
3) Something better?