Skip to Content
0
Former Member
Feb 09, 2009 at 08:25 PM

Extract strings from memo field

73 Views

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?