I need to get a sum from comma delimited text data e.g. “j12sdf,23fklsd,23sksdk” = 3
The number of entries varies and I need my zap to count the words and return a numeric value.
Is this possible?
Best answer
How do I calculate the sum of words in comma-delimited text data using Zapier?
- Beginner
Best answer by Troy Tessalone
One approach is to use these steps:
- Action: Looping - Create Loop from Text / Line Items
- Depends on the format of the data
- This will return the # of loop iterations (aka count value you are seeking to derive)
- You can map this variable to following Zap steps
- Action: Filter
- Conditions
- Loop Iteration exactly matches 1
- The Zap will only continue after loop iteration 1
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Will there always be values to sum or could there be 0 values to sum?
+14- Zapier Orchestrator & Solution Partner
- Answer
One approach is to use these steps:
- Action: Looping - Create Loop from Text / Line Items
- Depends on the format of the data
- This will return the # of loop iterations (aka count value you are seeking to derive)
- You can map this variable to following Zap steps
- Action: Filter
- Conditions
- Loop Iteration exactly matches 1
- The Zap will only continue after loop iteration 1
+6- Zapier Staff
That’s awesome
Happy Zapping! 🎉
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.