AnsweredAssumed Answered

Regular expression

Question asked by tapologo on Nov 22, 2017
Latest reply on Nov 22, 2017 by tapologo

Hello everyone. 

I need help with a regular expression that extracts comments only from the LastApproverComments variable. I tried below () but it doesn't trim out the part with outcome, date and time.

 

 

Here's the regular expression I used: .*Not\sRequired\).*

And the string:

John Doe (Approve) 21/11/2017 2:48 PM - 21/11/2017 2:48 PM
(John Doe) I want only this comment to appear
Michael Jackson (Not Required) 11/2/2015 2:48 PM -
Mike William (Not Required) 21/11/2017 2:48 PM -
Paul Smith (Not Required) 21/11/2017 2:48 PM -

Outcomes