Skip to main content
Nintex Community Menu Bar

Regular Expression to extract data after specific text

  • August 13, 2018
  • 1 reply
  • 68 views

Forum|alt.badge.img

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?

1 reply

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • August 14, 2019

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]*