Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

I have a cell in a Google Sheet that contains the result of 2 data inputs and it looks like this in the cell:

F11.20 OPIOID DEPENDENCE, UNCOMPLICATED Z79.891 LONG TERM (CURRENT) USE OF OPIATE ANALGESIC

I want to be able to extract F11.20 and Z79.891

I know if I use the SPLIT function in Formatter I can get these codes separated but knowing in which order the output occurs consistently is difficult because the input maybe different codes…

So is there another way to identify these codes F11.20 and Z79.891?

 

Thanks for the help

 

gml

 

Hi @blueguy 

Good question.

One option to try might be to ask AI.

You can prompt AI in a Zap action step.

Be sure to provide examples for the AI to use as part of the prompt to help train the AI.

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

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

 

Named Variables

You can also tell AI to use named variables to format the output. (see related topic below)

 

Somewhat related article about using ChatGPT as an Email Parser:

 

Thanks Troy….I will have to dig into the AI thing at some point.  I am guessing there is no feature in Zapier that will do that task…

 

GML

@blueguy

You can try using Formatter > Text > Extract Pattern (RegEx)

This involves knowing (regex) regular expression.

 

Code can be used as well.

 

If you need help, consider hiring a Certified Zapier Expert: https://zapier.com/experts/automation-ace

I am familiar with the use of RegEx from Google Sheets, but I have yet to venture into using formulas in my Zaps….I probably should try it out….it would be useful

 

thanks

 

gml

Hi @blueguy,

Glad to hear that Troy was able to point you to the right direction!

Venturing into using formulas in your Zaps could indeed open up a whole new world of possibilities for you. It's a powerful way to manipulate and transform your data exactly the way you want.

Remember, it's all about experimenting and learning. Don't hesitate to reach out if you have any questions or need any help along the way. Happy Zapping! 🚀

Terms & Conditions