topic Re: trim after space in QlikView https://community.qlik.com/t5/QlikView/trim-after-space/m-p/794602#M280810 <HTML><HEAD></HEAD><BODY><P>Thank you!</P><P><SPAN class="hps">The</SPAN> <SPAN class="hps">Resutat</SPAN> <SPAN class="hps">not</SPAN> <SPAN class="hps">produce the desired results</SPAN><SPAN>.</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">following</SPAN> <SPAN class="hps">number field</SPAN> <SPAN class="hps">there</SPAN> <SPAN class="hps">are</SPAN><SPAN>:</SPAN> <SPAN class="hps">V000-1000</SPAN> <SPAN class="hps">test</SPAN> <SPAN class="hps">test</SPAN> <SPAN class="hps">test</SPAN><SPAN>.</SPAN><BR /><SPAN class="hps">I would</SPAN> <SPAN class="hps">now like</SPAN> <SPAN class="hps">the right part</SPAN> <SPAN class="hps">de</SPAN> <SPAN class="hps">strings.</SPAN> <SPAN class="hps">In the example</SPAN> <SPAN class="hps">I had to</SPAN> <SPAN class="hps">Test Test Test</SPAN> <SPAN class="hps">get</SPAN> <SPAN class="hps">returned.</SPAN> <SPAN class="hps">The</SPAN> <SPAN class="hps">subfield</SPAN> <SPAN class="hps">function returns</SPAN> <SPAN class="hps">me</SPAN> <SPAN class="hps">back</SPAN> <SPAN class="hps">V000-1000</SPAN><SPAN>.</SPAN></P></BODY></HTML> Tue, 03 Mar 2015 09:46:18 GMT 2015-03-03T09:46:18Z trim after space https://community.qlik.com/t5/QlikView/trim-after-space/m-p/794599#M280807 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Hello everybody,</SPAN><BR /><SPAN class="hps">I</SPAN> <SPAN class="hps">have the following problem</SPAN><SPAN>.</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">an order number</SPAN><SPAN>.</SPAN> <SPAN class="hps">This number</SPAN> <SPAN class="hps">is divided into</SPAN> <SPAN class="hps">two parts.</SPAN> <SPAN class="hps">Example:</SPAN> <SPAN class="hps">v000-1000</SPAN> <SPAN class="hps">test</SPAN><SPAN>.</SPAN><BR /><SPAN class="hps">Now I want</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">part of the text</SPAN> <SPAN class="hps">expect</SPAN> <SPAN class="hps">located</SPAN> <SPAN class="hps">after the space</SPAN><SPAN>.</SPAN> <SPAN class="hps">In this case</SPAN> <SPAN class="hps">would be the</SPAN> <SPAN class="hps">'Test'</SPAN><SPAN>.</SPAN><BR /><SPAN class="hps">Here's what I</SPAN><SPAN>'ve tried:</SPAN><BR /><SPAN class="hps">subfield</SPAN> <SPAN class="atn hps">(</SPAN><SPAN class="atn hps">"</SPAN><SPAN>OP_NUMBER</SPAN> <SPAN class="atn hps">'</SPAN><SPAN>,' ',</SPAN> <SPAN class="hps">-1)</SPAN> <SPAN class="hps">as Adhesives</SPAN></P><P></P><P><SPAN class="hps">There I</SPAN> <SPAN class="hps">get</SPAN> <SPAN class="hps">everything</SPAN> <SPAN class="hps">in front of the</SPAN> <SPAN class="hps">empty</SPAN> <SPAN class="hps">mark</SPAN><SPAN>, so</SPAN> <SPAN class="hps">v000-1000</SPAN><SPAN>.</SPAN></P><P></P><P><SPAN class="hps">subfield</SPAN> <SPAN class="atn hps">(</SPAN><SPAN class="atn hps">"</SPAN><SPAN>OP_NUMBER</SPAN> <SPAN class="atn hps">'</SPAN><SPAN>,' ',</SPAN> <SPAN class="hps">+1</SPAN><SPAN>)</SPAN> <SPAN class="hps">as Adhesives</SPAN><BR /><SPAN class="hps">Here</SPAN> <SPAN class="hps">I get</SPAN> <SPAN class="hps">the same effect.</SPAN></P><P></P><P><SPAN class="hps">Where is</SPAN> <SPAN class="hps">my mistake</SPAN><SPAN>?</SPAN></P><P></P><P><SPAN class="hps">Many Thanks!</SPAN></P></BODY></HTML> Thu, 12 Feb 2015 13:15:19 GMT https://community.qlik.com/t5/QlikView/trim-after-space/m-p/794599#M280807 2015-02-12T13:15:19Z Re: trim after space https://community.qlik.com/t5/QlikView/trim-after-space/m-p/794600#M280808 <HTML><HEAD></HEAD><BODY><P>OP_NUMBER must not be included in '</P><P>use subfield(OP_NUMBER,<SPAN style="font-size: 8pt;">,' ', -1)&nbsp; should work</SPAN></P><P></P><P></P></BODY></HTML> Thu, 12 Feb 2015 13:22:01 GMT https://community.qlik.com/t5/QlikView/trim-after-space/m-p/794600#M280808 Anonymous 2015-02-12T13:22:01Z Re: trim after space https://community.qlik.com/t5/QlikView/trim-after-space/m-p/794601#M280809 <HTML><HEAD></HEAD><BODY><P>If OP_NUMBER is a field name then remove all the quotes around it: subfield(OP_NUMBER,' ', -1)</P></BODY></HTML> Thu, 12 Feb 2015 13:23:03 GMT https://community.qlik.com/t5/QlikView/trim-after-space/m-p/794601#M280809 Gysbert_Wassenaar 2015-02-12T13:23:03Z Re: trim after space https://community.qlik.com/t5/QlikView/trim-after-space/m-p/794602#M280810 <HTML><HEAD></HEAD><BODY><P>Thank you!</P><P><SPAN class="hps">The</SPAN> <SPAN class="hps">Resutat</SPAN> <SPAN class="hps">not</SPAN> <SPAN class="hps">produce the desired results</SPAN><SPAN>.</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">following</SPAN> <SPAN class="hps">number field</SPAN> <SPAN class="hps">there</SPAN> <SPAN class="hps">are</SPAN><SPAN>:</SPAN> <SPAN class="hps">V000-1000</SPAN> <SPAN class="hps">test</SPAN> <SPAN class="hps">test</SPAN> <SPAN class="hps">test</SPAN><SPAN>.</SPAN><BR /><SPAN class="hps">I would</SPAN> <SPAN class="hps">now like</SPAN> <SPAN class="hps">the right part</SPAN> <SPAN class="hps">de</SPAN> <SPAN class="hps">strings.</SPAN> <SPAN class="hps">In the example</SPAN> <SPAN class="hps">I had to</SPAN> <SPAN class="hps">Test Test Test</SPAN> <SPAN class="hps">get</SPAN> <SPAN class="hps">returned.</SPAN> <SPAN class="hps">The</SPAN> <SPAN class="hps">subfield</SPAN> <SPAN class="hps">function returns</SPAN> <SPAN class="hps">me</SPAN> <SPAN class="hps">back</SPAN> <SPAN class="hps">V000-1000</SPAN><SPAN>.</SPAN></P></BODY></HTML> Tue, 03 Mar 2015 09:46:18 GMT https://community.qlik.com/t5/QlikView/trim-after-space/m-p/794602#M280810 2015-03-03T09:46:18Z