https://community.cloudera.com/t5/Support-Questions/how-to-split-name-based-on-special-character-in-hive/m-p/242006#M203809 <P>Tahnks Naresh for your response.</P><P>there is one more scenario which I received today along with above requirements.</P><P>If the individual name has only three words (I mean without title) then the fullname should be like below:</P><P>current state:</P><TABLE><TBODY><TR><TD>fullname</TD></TR><TR><TD>jkl! mno pqr</TD></TR></TBODY></TABLE><P>expected</P><TABLE><TBODY><TR><TD>Last</TD><TD>Title</TD><TD>First</TD><TD>Middle</TD></TR><TR><TD>jkl</TD><TD></TD><TD>mno</TD><TD>pqr</TD></TR></TBODY></TABLE> Mon, 14 Jan 2019 07:59:26 GMT madankumarpuril 2019-01-14T07:59:26Z