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?