Skip to main content

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?

Hi,


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.


^[a-zA-Z,s()d*/*:]+[-sd*/:AaPpMm]*

Reply