How to Parse First Middle ,Mid Names and Last name from a String

         How to Parse First Middle ,Mid Names and Last name from a String 

USE of REG_EXTRACT Function 

SRC IS :- John M Doe IRA

REG_EXTRACT(NAME,'(\W+)\S+(\W+)\S+(W+)\S+(W+)',1)

REG_EXTRACT(NAME,'(\W+)\S+(\W+)\S+(W+)\S+(W+)',2)

REG_EXTRACT(NAME,'(\W+)\S+(\W+)\S+(W+)\S+(W+)',3)

REG_EXTRACT(NAME,'(\W+)\S+(\W+)\S+(W+)\S+(W+)',4)

FNAME:-John 

MNAME:-M 

LNAME:-Doe 

IDEBTIFIER:-IRA

THANKS:-

:)