AnsweredAssumed Answered

Regular Expression to extract data after specific text

Question asked by rickwhit78 on Aug 13, 2018

I'm trying to build a Regular Expression to extract text from a string.  This is being fed from the variable "Approver Comments" on a Workflow Task.  The format will always be:

"Non Important text",Timestamp (ex. 08/13/2018 12:21 PM) (Lastname, Firstname) "Important Text"

 

A full example is:  ApproverLastname, ApproverFirstname (Assign to This Guy) 8/13/2018 12:20 PM - 8/13/2018 12:21 PM (AnalystLastname, AnalystFirstname) Test to view comments by approver.

 

I want to exclude the "Non Important text" and Timestamp to extract a variable that only includes the:

(Lastname, Firstname) "Important Text" data.  The "Important Text" can also be anything; such as text, a date, numbers, or any combination of the aforementioned text; but it always follow a (Lastname, Firstname) indicator. 

 

I've tried several variations of Splits and Extracts with no luck and I'm starting to get frustrated!  Does anyone have any suggestions?

Outcomes