Best answer

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

  • 1 March 2024
  • 5 replies
  • 22 views

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

View original

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

5 replies

Userlevel 7
Badge +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
Badge +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
Badge +6

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

Happy Zapping! 🎉