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
Bookmarks