Finding Specific String within larger String with Qualifications

[Jezzzza]

I have a report showing an audit trail of users and the output is very very messy, no delimiters, massive amount of text in single cell. We have a user who changed the job code field on an unknown number of users, and I am trying to find the last instance it occurred using a particular string and two search parameters , then pulling everything after another string that comes before it.

for example, in this original string:

I am particularly needing the last occurrence of "Changed Job code" but I also need to know the date on which it occurred, so specifically in this example I would need everything from the final green "Updated at..." string to the end but only if it is the "updated at" occurring before the last occurrence of "Changed job code" if that is even possible.

Currently I have this formula:
=IF(AND(COUNTIF(J3,"*Denise*"),"Yes","No",COUNTIF(J3,"*job code*")),"Changed Job code from"&TEXTAFTER(J3,"Changed Job code from",-1),"")

which is working to find all cells that have anything changed by Denise and also including any change in job code, then pulling the data after the last job code change, but I still need to also know on what date it occurred (green highlighted text in image).

Result in column B

Honestly not sure if this is even possible, but if so, it would be a life saver.

Thanks in advance!

 

[Jezzzza]

Amazing, thank you so much, that worked perfectly.

To verify, this will find the last instance of those two strings regardless of the name attached as the 'updater' and if it doesn't find 'change job code' it returns blank?

 

[Jeffrey Mahoney]

BTW, Functions used in cells can bog Excel down if you have too many rows.

 

[Jezzzza]

Thanks again!

 

[Jeffrey Mahoney]

Yup, last Changed Job code or blank