Best answer

How can I extract information from the content that Zapier receives?

  • 7 August 2021
  • 1 reply
  • 387 views

The title probably didn’t make sense. 

Here’s what I want to do…

I created a bot that posts a message to a special discord channel that contains: the current song, song artist, and length of a song that I am listening to on Spotify. Every time a message is posted to that channel in Discord, Zapier pulls that message content (which is good!). But I want to get the length of the song separately into zapier as well so that I can display the content for a certain amount of time and then remove it (the length of the song).

Are there any substring() methods or string manipulation methods in Zapier that I can use to just get the END of the “content” that it pulls from discord?

As you can see, it does provide a timestamp, but that doesn’t help because I would need a second timestamp of when the song ends to even think about using that method. So the only thing I can think of is to use the “Content” option and then extract text from it.

 

Any ideas how to extract info out of the “content” field so that I can do some math on it?

icon

Best answer by Troy Tessalone 9 August 2021, 18:12

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.

1 reply

Userlevel 7
Badge +14

Hi @Garebear

Try one of these options…

Formatter: https://zapier.com/help/doc/how-use-formatter-functions

OR

Code: https://zapier.com/apps/code/help