3 Replies Latest reply on May 6, 2013 10:31 AM by deathrobot

    Best way to swap a list of values

    deathrobot

      Title

      Best way to swap a list of values

      Post

           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?

           Thanks.