https://community.qlik.com/t5/Talend-Studio/Splitting-a-String-at-the-Comma-into-FirstName-and-LastName/m-p/2320316#M90468 row1.fullname.contains(",") ? row1.fullname.replaceAll(",.*$", "") : row1.fullname &nbsp; --&gt; to populate out.Lastname<BR />row1.fullname.contains(",") ? row1.fullname.replaceAll("^.*,", "") : "" &nbsp; --&gt; to populate out.Firstname<BR />Check the syntax before to go<BR /><BR />Regards,<BR />TRF Wed, 25 Jan 2017 17:43:10 GMT TRF 2017-01-25T17:43:10Z https://community.qlik.com/t5/Talend-Studio/Splitting-a-String-at-the-Comma-into-FirstName-and-LastName/m-p/2320315#M90467 <P>In tMap, is there a way to test a string to see if it has a comma, and if it does, split it at the comma into FirstName and LastName?<BR /><BR />Thanks in advance,<BR /><BR />HLeyes</P> Wed, 25 Jan 2017 17:33:17 GMT https://community.qlik.com/t5/Talend-Studio/Splitting-a-String-at-the-Comma-into-FirstName-and-LastName/m-p/2320315#M90467 HLeyes 2017-01-25T17:33:17Z https://community.qlik.com/t5/Talend-Studio/Splitting-a-String-at-the-Comma-into-FirstName-and-LastName/m-p/2320316#M90468 row1.fullname.contains(",") ? row1.fullname.replaceAll(",.*$", "") : row1.fullname &nbsp; --&gt; to populate out.Lastname<BR />row1.fullname.contains(",") ? row1.fullname.replaceAll("^.*,", "") : "" &nbsp; --&gt; to populate out.Firstname<BR />Check the syntax before to go<BR /><BR />Regards,<BR />TRF Wed, 25 Jan 2017 17:43:10 GMT https://community.qlik.com/t5/Talend-Studio/Splitting-a-String-at-the-Comma-into-FirstName-and-LastName/m-p/2320316#M90468 TRF 2017-01-25T17:43:10Z https://community.qlik.com/t5/Talend-Studio/Splitting-a-String-at-the-Comma-into-FirstName-and-LastName/m-p/2320317#M90469 Thanks, TRF.&nbsp; I'll test it out!<BR /><BR />HLeyes Mon, 30 Jan 2017 21:51:52 GMT https://community.qlik.com/t5/Talend-Studio/Splitting-a-String-at-the-Comma-into-FirstName-and-LastName/m-p/2320317#M90469 HLeyes 2017-01-30T21:51:52Z