Extracting a specific phrase to a new cell from a large amount of text

[LillyD]

Hi,

I am trying to exctract a specific phrase from one cell that contains a large amount of information, to a new cell / column.  I need to do this so I can isolate the corruption information from the rest of the information, any one got any ideas please?

Example given below, I would like to return just the all the items in the red box, these appear for mulitple users with mulitple locations but what seems to the standard is the "A corrupted item was encountered:"

Thanks in advance

[ImkeF]

I believe adding a column with extracting everything after the delimiter would work here as well:

[Stachu · Accepted solution]

with the whole string in one cell it is a bit diffficult
I would do it in M, with following logic:
1) split that text into multiple rows,
2) split that into multiple columns: time stamp, whatever is in the brackets, and then actual message
3) create a dictionary of error messages that have to be searched for (unless you're sure that "A corrupted item was encountered:" is the only error you may get
4) create a flag indicating if the rows from 1) contain one of the errors
5) filter only error rows and remove duplicates to limit the data (unless multiple time stamps are relevant for this)

[LillyD]

Thank you 🙂