topic Re: Extracting Names in Talend Studio https://community.qlik.com/t5/Talend-Studio/Extracting-Names/m-p/2232613#M22522 Solution will be<BR />tFileInputDelimited --&gt; tmap --&gt; tlogrow<BR /><BR />Within tmap you can create three extra port in output side for 1st name, middle name and last name using java's substring and indexOf method.<BR /><BR />Accept solution if it works Sat, 07 Sep 2019 08:56:28 GMT Anonymous 2019-09-07T08:56:28Z Extracting Names https://community.qlik.com/t5/Talend-Studio/Extracting-Names/m-p/2232612#M22521 <P>Hello all,</P> <P>I am getting name value in a single column as "LastName,FirstName MiddleName".</P> <P>&nbsp;</P> <P>I want to extract all three names separately and load into three different columns using TMap.</P> <P>&nbsp;</P> <P>Different cases are</P> <TABLE> <TBODY> <TR> <TD><P><STRONG>FULLNAMES</STRONG></P></TD> <TD><P><STRONG>FirstName</STRONG></P></TD> <TD><P><STRONG>MiddleName</STRONG></P></TD> <TD><P><STRONG>LastName</STRONG></P></TD> </TR> <TR> <TD><P>last,first middle</P></TD> <TD><P>first</P></TD> <TD><P>middle</P></TD> <TD><P>last</P></TD> </TR> <TR> <TD><P>last1 last2,first middle</P></TD> <TD><P>first</P></TD> <TD><P>middle</P></TD> <TD><P>last1 last2</P></TD> </TR> <TR> <TD><P>last,first</P></TD> <TD><P>first</P></TD> <TD><P>NULL</P></TD> <TD><P>last</P></TD> </TR> <TR> <TD><P>singleword</P></TD> <TD><P>singleword</P></TD> <TD><P>NULL</P></TD> <TD><P>NULL</P></TD> </TR> <TR> <TD><P>last,first middle extra</P></TD> <TD><P>first</P></TD> <TD><P>middle extra</P></TD> <TD><P>last</P></TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Please Help.</P> Sat, 16 Nov 2024 04:44:45 GMT https://community.qlik.com/t5/Talend-Studio/Extracting-Names/m-p/2232612#M22521 Anonymous 2024-11-16T04:44:45Z Re: Extracting Names https://community.qlik.com/t5/Talend-Studio/Extracting-Names/m-p/2232613#M22522 Solution will be<BR />tFileInputDelimited --&gt; tmap --&gt; tlogrow<BR /><BR />Within tmap you can create three extra port in output side for 1st name, middle name and last name using java's substring and indexOf method.<BR /><BR />Accept solution if it works Sat, 07 Sep 2019 08:56:28 GMT https://community.qlik.com/t5/Talend-Studio/Extracting-Names/m-p/2232613#M22522 Anonymous 2019-09-07T08:56:28Z