I have a field with workflow history. I need the status at the end of the sentence which is in " " to be seperated to it's own column. There are other lines in the history with items in " " that I do not need to bring over. Only the furthest to the right status in " " when changed status or set status is mentioned. (do not need file upload or change in due date). Example below - see attached for it in excel. Thanks - 1st post.
| Have | Desired Results |
| Jane Doe has changed status from "Assigned" to "Not Submitted" | Not Submitted |
| Jane Doe has set status to "Assigned" | Assigned |
| Jane Doe has uploaded the file "LI7130a_12_12_17.comp.pdf" | |
| Jane Doe has changed status from "Not Submitted" to "Submitted" | Submitted |
| Jane Doe has set the due date of status "In Review" to 12/15/2017 | |
| Jane Doe has assigned responsibility to John Doe. | |
| Jane Doe has changed status from "Submitted" to "In Review" | In Review |
| Jane Doe has transferred responsibility from Jane to John. | |
| Jane Doe has changed status from "In Review" to "Review Completed" | Review Completed |
| Jane Doe has changed status from "Review Completed" to "Audit Form In Progress" | Audit Form in Progress |
| Jane Doe has changed status from "Audit Form In Progress" to "Audit Form Completed" | Audit Form Completed |
| Jane Doe has changed status from "Audit Form Completed" to "Approved with Contingencies" | Approved with Contingencies |
| Jane Doe has changed status from "Approved with Contingencies" to "Final Needed" | Final Needed |
| | |
| 202012 | |
| Jane Doe has changed status from "Final Needed" to "Final Submitted" | Final Submitted |
| Jane Doe has set the due date of status "In Review" to 2/12/2018 | |
| Jane Doe has uploaded the file "223203 LI7130a_1_25_18.comp.pdf" | |
| Jane Doe has changed status from "Final Submitted" to "Final Accepted" | Final Accepted |
