cancel
Showing results for 
Search instead for 
Did you mean: 
rickwhit78
Nintex Newbie

Regular Expression to extract data after specific text

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?

0 Kudos
Reply
1 Reply
Nintex Employee
Nintex Employee

Re: Regular Expression to extract data after specific text

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*/*:]+[\-\s\d*\/\:AaPpMm]*
0 Kudos
Reply