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 tried to extract the payment date and bill from the raw snippet as below.

Raw Snippet - 

“myAT&T Your online AT&T bill is ready, IChing. Hi IChing, Your monthly wireless bill is now available at myAT&T. Account number: 436030493836 Payment due: 12/03/2024 Bill total: $220.61”

I used Text in Formatter by Zapier with the transform below -

“extract the date in 'mm/dd/yyyy' format after 'Payment due: ' and the number after 'Bill total: $' from 1. Raw Snippet”

However I got the error 

Failed to create a text transform in Formatter by Zapier

The app returned "Transform "extract the date in 'mm/dd/yyyy' format after 'Payment due: ' and the number after 'Bill total: frommyAT" not found".

Any help will be appreciated.  Thanks.

Hi ​@Iching 

Help us have more context by posting screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.

​@Iching 

Resources for email parsing:

 

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Please see the attachment for the screen shots.

Thank you for the help.

​@Iching 

For the Formatter step, in the CONFIGURE tab, for the Transform field, you need to select an option from the dropdown list.

Use s...] button to switch to ‘Static’ mode.

 

What value of the transform should I use if I switching to static?  Is it Extract Number or Extract Pattern or something else?

Thanks,

I set it to Extract Pattern from input of Raw Snippet and with Pattern ‘Payment due:’.  I am expecting the date after the payment due which not happening.

​@Iching 

For us to have current info, post screenshots showing how your Zap Formatter step is configured in EDIT mode with the field mappings visible.

Is this you are looking for?

I configured it to static but I don’t know which transform I should use - extract number, extract pattern, or find?  

 

I did attached the screen shots in the word doc attached in the previous reply.

​@Iching 

Perhaps another option for you to explore is using this Zap action: AI by Zapier - Analyze and Return Data

Help: https://zapier.com/apps/ai/integrations#help

 

Troy, 

Thank you, I got it to work from the help of AI by Zapier.   Appreciate your help.

Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.

Reply


Terms & Conditions