Skip to main content
Best answer

Split text out is duplicate and I can't use for paste in google sheet

  • September 4, 2024
  • 3 replies
  • 26 views

I use Formatter by Zapier to split text but it create duplicate in line item. How do I fix it?

 

Segment Index = All (as Line-items)

Best answer by TonkatsuRamen

I try this solution (Formatter > Utilities > Line Items to Text) and it work. Thank you

View original
Did this topic help you find an answer to your question?
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

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31501 replies
  • September 4, 2024

Hi @TonkatsuRamen 

For us to have more info, post screenshots of the DATA IN tab so we can see how the Formatter step is configured.

Also, post screenshots showing how the original data is structured from the previous step.

You may be trying to pass in an array of items.

You may have to try using this Zap action first: Formatter > Utilities > Line Items to Text

That will flatten the array into a string of text.


  • Author
  • New
  • 1 reply
  • Answer
  • September 5, 2024

I try this solution (Formatter > Utilities > Line Items to Text) and it work. Thank you


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7859 replies
  • September 5, 2024

Thanks so much for circling back in here @TonkatsuRamen to confirm that worked for you. And thank you @Troy Tessalone for the suggestion. The Community greatly appreciates it! 🤗 🧡

Seems like things are sorted for the moment but please do reach out in the Community again if you get stuck again in future.

Until then, happy Zapping! ⚡