AnsweredAssumed Answered

Best way to swap a list of values

Question asked by deathrobot on May 5, 2013
Latest reply on May 6, 2013 by 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.

Outcomes