Parsing Issue - Regex

[jerry_jk]

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

[Qiu]

@jerry_jk 
Maybe we need more date to test.

[jerry_jk]

Have added additional sample examples, please note that the each comment can go into multiple lines for Developer and Tester. But yes, each new comment would always start with name and timestamp

[Qiu · Accepted solution]

@jerry_jk 
This should work.

[danilang]

Hi @jerry_jk 

Here's a dynamic way that uses a user role table to split the comments between Developer and Tester

In the results, the cells that have a red triangle have embedded line breaks.  There's no way to show all the expanded data at once, so I showed the contents of the highlighted cell to display the internal format.

Dan

[jerry_jk]

Thanks @Qiu and @danilang, both the solutions worked perfectly.

[Qiu]

@jerry_jk 
Glad to helo and thank you for the accept mark. 😁