https://community.qlik.com/t5/Talend-Studio/Removing-characters-before-first-occurence-of-space-using-tMap/m-p/2330184#M99280 Assuming your string column is named "col1", set your output column to: row1.col1. <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">substring</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">(</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">row1.col1</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">.</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">lastIndexOf</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">(</FONT></FONT> <FONT color="#7d2727"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">' '</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">)+</FONT></FONT> <FONT color="#7d2727"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">1</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">)</FONT></FONT> Fri, 24 Mar 2017 13:44:36 GMT cterenzi 2017-03-24T13:44:36Z https://community.qlik.com/t5/Talend-Studio/Removing-characters-before-first-occurence-of-space-using-tMap/m-p/2330183#M99279 Hi Guys, <BR />I just wanted to ask if is it possible to remove all the characters before the first occurrence of space in a string using tMap? <BR />For example: <BR />Input: "This is a sentence" <BR />Ouput" "is a sentence" <BR />Thanks! <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133049iD780B7DE0116E4D1/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACJ.png" alt="0683p000009MACJ.png" /></span> Fri, 24 Mar 2017 05:27:07 GMT https://community.qlik.com/t5/Talend-Studio/Removing-characters-before-first-occurence-of-space-using-tMap/m-p/2330183#M99279 Anonymous 2017-03-24T05:27:07Z https://community.qlik.com/t5/Talend-Studio/Removing-characters-before-first-occurence-of-space-using-tMap/m-p/2330184#M99280 Assuming your string column is named "col1", set your output column to: row1.col1. <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">substring</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">(</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">row1.col1</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">.</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">lastIndexOf</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">(</FONT></FONT> <FONT color="#7d2727"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">' '</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">)+</FONT></FONT> <FONT color="#7d2727"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">1</FONT></FONT> <FONT color="#303336"><FONT face="Consolas, Menlo, Monaco, " lucida="" console="">)</FONT></FONT> Fri, 24 Mar 2017 13:44:36 GMT https://community.qlik.com/t5/Talend-Studio/Removing-characters-before-first-occurence-of-space-using-tMap/m-p/2330184#M99280 cterenzi 2017-03-24T13:44:36Z https://community.qlik.com/t5/Talend-Studio/Removing-characters-before-first-occurence-of-space-using-tMap/m-p/2330185#M99281 Variation :&nbsp;<FONT size="1"><FONT face="Verdana, Helvetica, Arial, sans-serif">row1.col1.replaceAll("^.* ", "")</FONT></FONT> Fri, 24 Mar 2017 15:49:36 GMT https://community.qlik.com/t5/Talend-Studio/Removing-characters-before-first-occurence-of-space-using-tMap/m-p/2330185#M99281 TRF 2017-03-24T15:49:36Z