In this case, you’d want to use a combination of a couple different String functions and a little math as well. I’ve built a little example below.
The Find, Add, and Substring cards are the important parts of this. I simply included a Trim card to make sure that there aren’t any leading or trailing spaces on the final output of the process.
The reason for the Add card is that the Find card is going to give you the index that a particular string starts within another string. So in the case of “Southern MTG Southland - Meeting Activity Report.xlsx”, “MTG” starts at index 9. But if you use that value for the Substring card, you’ll include MTG in the final string. So you have to add to that number 9 in order to get the actual index you’re looking for.
If you wanted it to be a little more dynamic, you could use a “String Length” card on the “MTG” string to find the length and then add that to the index. This way, if the “MTG” string got changed and became longer or shorter, you wouldn’t need to change the number in the Add card. It would change automatically.