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

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?

Page 1 / 1

Hi @Msarin

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

There will always at least one value

@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

Thank you! The loop worked perfectly :-)

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

Happy Zapping!

Sign up