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?
I am no expert in Regular expressions but the following expression used with a replace and blank text will remove the unwanted part of the sample text.