Hello All,
I'm trying to create columns based upon 'Tester' and 'Developer' comments using Regex tool but not getting desired output. Below is an sample example where tester and developer are adding comments which is an free text field. Any new comments prefixed by Developer/Tester name and timestamp. Appreciate your help in this regard
Current Grid
| ID-101 | John 11/04/2021: Defect raised on tool John 11/04/2021: Defect allocated to Developer Sean 13/04/2021: Analyzing the defect. Sean 14/04/2011: Logs requested, previous logs shared were corrupt. Request you re-execute and share logs John 16/04/2021: Please provide ETA Sean 17/04/2021: Fix deployed, please test John 18/08/2021: Retested, Issue closed |
| ID-102 | Sean 17/04/2021: Seems to be invalid issue John 11/04/2021: Re-validating the issue John 11/04/2021: Issue Closed |
| ID-103 | John 20/04/2021: Environment seems to be down Sean 20/04/2021: Please check now |
| ID-104 | Sean 20/04/2021: Awaiting logs from team Sean 20/04/2021: Issue replicated, ETA 04/25 Sean 20/04/2021: Fix Deployed, Please test |
Expected outcome
| ID | Developer | Tester |
| ID-101 | Sean 13/04/2021: Analyzing the defect. Sean 14/04/2011: Logs requested, previous logs shared were corrupt. Request you re-execute and share logs Sean 17/04/2021: Fix deployed, please test | John 11/04/2021: Defect raised on tool John 11/04/2021: Defect allocated to Developer John 16/04/2021: Please provide ETA John 18/08/2021: Retested, Issue closed |
| ID-102 | Sean 17/04/2021: Seems to be invalid issue | John 11/04/2021: Re-validating the issue John 11/04/2021: Issue Closed |
| ID-103 | Sean 20/04/2021: Please check now | John 20/04/2021: Environment seems to be down |
| ID-104 | Sean 20/04/2021: Awaiting logs from team Sean 20/04/2021: Issue replicated, ETA 04/25 Sean 20/04/2021: Fix Deployed, Please test | |
