Need parsing help - column contains multiple data points needed

[Clynch039]

Hi all, 

I'm trying to parse through this line to capture the due date, completion date and status but I can't seem to figure it out. Any suggestions or guidance would be greatly appreciated!

[{"hasLaunchMailSent":true,"_id":"ObjectId(\"610708feef7cd7e1dafb9c89\")","courseNumber":"E-55L43","courseName":"Test Course","dueDate":"5/26/2021","completionDate":"04/07/2021 10:04:43 PM","status":"Completed"}]

Desired output 

Due Date	Completion Date	Status
5/26/2021	04/07/2021	Completed

[Kakuffo]

HI @Clynch039  the text looks like JSon and i have managed to get you a solution working. We have specific JSONparse tool that handles this format very

easily.

Please view my attached workflow .

If this solves your problem kindly mark this as a solution so others can find the answer quickly.