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.

Question

Extracting specific codes from a Google Sheet cell using Zapier Formatter Split function.

  • 17 June 2023
  • 5 replies
  • 27 views
B
Userlevel 3
Badge +3

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

 

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

5 replies

Troy Tessalone
Userlevel 7
Badge +14

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:

 

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

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

Troy Tessalone
Userlevel 7
Badge +14

@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

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

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

ken.a
Userlevel 7
Badge +6

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