Extract Text from Data Array into Cells Easily

How can I extract a specific portion of text from a data array (text) into cells? For example, I want to extract the word TEST from the entire section, which is contained in the {"Campaign Instance":"TEST","Contact Status":"TEST","Conversation Status":"TEST"........ section, given that it appears after "Contact Status":