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 -