Question about getting final word of each row.

[dhxodud96]

I'm having trouble with getting final word of each song title.

In order to use the left, right, etc. of the Formula tool, i need to set the length of the words.

Currently the last word in data are of different lengths.
Which tool can I use to get the value?

Always thanks for helping me.

[aatalai · Accepted solution]

@dhxodud96 put this in the formula tool

ReverseString(
GetWord(ReverseString([Top 100]), 0))

also attached a workflow for reference

[dhxodud96]

thank you so much! have a nice day :)