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!)
Best answer by Troy Tessalone
Give this Javascript Code a try:
The code returns a Set object with each option as it’s own data point.
+14Hi
Try using Formatter > Utilities > Text to Line Items: https://zapier.com/help/create/basics/use-line-items-in-zaps
Sadly
output
1
1 Clear
2
1 Clear
3
1 Clear
4
1 Clear
+14Or you can use a Javascript Code step like this;
Hi
+14Give this Javascript Code a try:
The code returns a Set object with each option as it’s own data point.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
