Best answer

How do I calculate the sum of words in comma-delimited text data using Zapier?

Userlevel 1

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?

icon

Best answer by Troy Tessalone 1 March 2024, 17:15

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

Userlevel 7

+14

Hi @Msarin

Will there always be values to sum or could there be 0 values to sum?

Userlevel 1

There will always at least one value

Userlevel 7

+14

@Msarin

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

Userlevel 1

Thank you! The loop worked perfectly :-)

Userlevel 7

That’s awesome @Msarin! Big thanks to Troy for pointing you in the right direction!

Happy Zapping! 🎉

Sign up