Workflow for changing US state names to state postal abbreviations

Workflow for changing US state names to state postal abbreviations

Currently we have a workflow that automatically corrects the country fields any time anyone enters "US," "us", "USA", "usa" or "United States of America" to the standard "United States."

This works great. However, in order to accomplish this I had to create six workflows - one for Leads, two for Accounts (billing and shipping), three for Contacts (billing, mailing, other).

We have some address data in which the US state has been entered as its full name, e.g. Alabama, instead of its postal abbreviation, e.g. AL. (Some of this data comes from Zia and the "enrich data" tool, which is annoying.) When we print mailing labels, we want to only have correct US postal abbreviations.

I'm aware I could create a workflow that would accomplish this -- but I'd have to create a workflow for EVERY state/territory/district name, 50+, six times. There's no way I can justify spending that much time creating workflows by hand.

Is there a way that either:

a) something like this exists in a prebuilt fashion
b) Deluge function(s) could accomplish this?

I don't mind creating six Deluge functions that are essentially "replace x with y" 50+ times because I can copy and paste things. But having to do that clicking through the workflow rules interface would take hours.

Any suggestions?

Thanks!