SQL name parsing

Question

I have a name field that includes father, mother, spouse, child, and sibling and I need to parse out the names into father name, mother name, spouse name, child name and sibling name fields. An example is father John smith mother Jane doe. How can I do this?