I need to extract all of the strings from a memo field, Change Log, that start with a specific phrase:
Changed Assignee Group to:
Following that phrase, the name of the Assignee Group is notated. This string may be found multiple times in the memo log.
I need the name of the group that follows the phrase. The Assignee Group name is not a constant length, and there could be any of 14 groups.
I am using a formula that I found in the forum, but it only works only the first iteration of the phrase.
Any suggestions?