Example.xlsx

I have data from Report failures in text format Failed Data: Person Report failed at refresh at 17/12/2021 10:33 on myworkspace. Final status: Completed as an example.

I want to be able to place certain data into rows from this text string.

Example would be after getting the report name which is the text between 'Failed Data: Person Report failed at Refresh' into a column.

I tried Text Before and after in a formula but hasn't thus been successful.

Any ideas appreciated.

thank you