About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How can I change state misspellings in an address form to the correct US Post Office abbreviations?
Best answer

How can I change state misspellings in an address form to the correct US Post Office abbreviations?

  • 9 March 2024
  • 9 replies
  • 48 views
I

What is the bast way to identify a multitude of misspellings in a form for state in an address and convert it to the standard 2 capital letters used by the US Post office

icon

Best answer by Troy Tessalone 8 April 2024, 20:57

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @IULMAN 

AI via ChatGPT/OpenAI will be your most flexible option.

 

Action: Formatter > Text > Uppercase

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
I

Come on Mr. Obvious read the question there’s more to it than just capitalization. 

Troy Tessalone
Userlevel 7
Badge +14

@IULMAN 

Try AI as suggested.

AI via ChatGPT/OpenAI will be your most flexible option.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@IULMAN 

Best would be to address the formatting by making the input list a standardized dropdown list on the form.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
I

Yes that is the logical solution but unavailable in this instance. I understand that there is a way to access a list or sheet of data (the proper abbreviation) and have it used to replace a list of misspellings? However the syntax escapes me. That is what I seek here. 

Troy Tessalone
Userlevel 7
Badge +14

@IULMAN 

Try prompting AI to reference the input value against the list of values and return the derived value.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
I

@IULMAN

Try prompting AI to reference the input value against the list of values and return the derived value.

This is the right idea but I am a novice, can you specify the zap trigger and action (I think those are the terms). Any additional help would be greatly appreciated.

 

Thanks,  Peter

Troy Tessalone
Userlevel 7
Badge +14

@IULMAN 

You would need to specify the app you are trying to use for the Zap trigger step.

 

List of available Zap triggers/actions:

ChatGPT: https://zapier.com/apps/chatgpt/integrations#triggers-and-actions

OpenAI: https://zapier.com/apps/openai/integrations#triggers-and-actions

 

It can take some testing and tweaking to get the AI prompt right for the desired output.

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
I

I guess I’m going to have to roll up my mental sleeves on this one. Thanks.

Terms & Conditions