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.

Best answer

Formatter text to line items not outputting as separate line items

  • April 6, 2025
  • 3 replies
  • 41 views
C

This post was split from the topic: 

hey Guys! 

 

same issue I have now, 

 

 

on Formatier Stage it convert to line items, 

 

but on the next stage show me the whole answer 

 

please help !

 

I fighting for 2 days…. 

 

 

many thanks 

 

Hi @erusso 

Perhaps try these options:

 

Formatter > Text > Split

Use 2 to isolate the desired value.

 

Formatter > Text > Extract Pattern

Ask ChatGPT for help configuring the regex.

 

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing sensitive details.

Best answer by SamB

 Hi ​@Cyril_Sig, welcome to the Community! 🎉

Hope you don’t mind but I’ve moved your post out into a new topic so we can address it separately—as it looks like the issue you’re running into is a bit different from the original topic, which was about separating values from a Webhooks trigger’s Raw Body field.

If there’s only ever going to be one set of booking fields from the email then you might be better of changing that Formatter step from a Formatter (Utilities > Text to Line-item) action to be a Formatter (Text > Split Text) action instead. This would output the booking information as individual fields instead of line items.

With that action you’d select the output from the relevant ChatGPT action for the Input field, set the Separator to be , and select All (as Separate Fields) to be the Segment Index:

12acee3ca3330b228e5f08511f807c5d.png
That should then allow you to select the each field separately: 

9e297e861749f6402c16c777c86cb573.png

Check out our Use Formatter to split text in Zaps guide to learn more about how to use that sort of Formatter action.

Can you give that a try and let me know if that does the trick?

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

3 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 9751 replies
  • Answer
  • April 7, 2025

 Hi ​@Cyril_Sig, welcome to the Community! 🎉

Hope you don’t mind but I’ve moved your post out into a new topic so we can address it separately—as it looks like the issue you’re running into is a bit different from the original topic, which was about separating values from a Webhooks trigger’s Raw Body field.

If there’s only ever going to be one set of booking fields from the email then you might be better of changing that Formatter step from a Formatter (Utilities > Text to Line-item) action to be a Formatter (Text > Split Text) action instead. This would output the booking information as individual fields instead of line items.

With that action you’d select the output from the relevant ChatGPT action for the Input field, set the Separator to be , and select All (as Separate Fields) to be the Segment Index:

12acee3ca3330b228e5f08511f807c5d.png
That should then allow you to select the each field separately: 

9e297e861749f6402c16c777c86cb573.png

Check out our Use Formatter to split text in Zaps guide to learn more about how to use that sort of Formatter action.

Can you give that a try and let me know if that does the trick?

C
  • Cyril_Sig
  • Author
  • New
  • 1 reply
  • April 7, 2025

It worked! thanks a lo for helping me out!

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 9751 replies
  • April 7, 2025

You are most welcome, ​@Cyril_Sig! 🤗 I’m so pleased that did the trick.

Feel free to reach back out if we can help with anything else. In the meantime, happy Zapping! 😁⚡

Terms & ConditionsAccessibility statement