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 am trying to use Formatter to split a string of 6 test responses and have encountered the problem that if a test is not complete, the value is empty. So a typical response might be:

 

clear, clear, , ,clear, clear

I need the response to be:

0: clear
1: clear
2: 
3:
4: clear
5: clear

But instead I just get 1-4 = clear

Any ideas on how to solve for this within formatter, or is there a code alternative (am not really a coder!)

Hi @PeterCera 

Try using Formatter > Utilities > Text to Line Items: https://zapier.com/help/create/basics/use-line-items-in-zaps

Sadly @Troy Tessalone that just gives this:

 

output

1

   1 Clear

2

    1 Clear

3

    1 Clear

4

     1 Clear

@PeterCera 

I tried this:

 

And got this:

 

@PeterCera 

Or you can use a Javascript Code step like this;

 

 

 

Hi @Troy Tessalone this is great thanks, an works - but when I go to plug in a response into a google sheet update lower down the Zap, the field available to me from the code step still reads like an array of Result (Clear,clear,,clear,clear) - I can’t figure out how to, for example just extract the 5th item (“Clear”) which corresponds to the field I’m trying to populate. Thanks so much for your thoughts

 

@PeterCera 

Give this Javascript Code a try:

 

The code returns a Set object with each option as it’s own data point.

 

Terms & Conditions