topic Re: Trim string in QlikView https://community.qlik.com/t5/QlikView/Trim-string/m-p/579126#M215339 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>mid(FIELD, 4)</P><P></P><P>As an example:</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">01.test1 would get test1</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Hope this helps!</SPAN></P></BODY></HTML> Thu, 27 Feb 2014 14:06:10 GMT jerem1234 2014-02-27T14:06:10Z Trim string https://community.qlik.com/t5/QlikView/Trim-string/m-p/579125#M215338 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>I have a field with some values and every row starts with "01., 02., ....16." that I want to remove. </P><P>What is the best solution?</P></BODY></HTML> Thu, 27 Feb 2014 14:02:52 GMT https://community.qlik.com/t5/QlikView/Trim-string/m-p/579125#M215338 2014-02-27T14:02:52Z Re: Trim string https://community.qlik.com/t5/QlikView/Trim-string/m-p/579126#M215339 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>mid(FIELD, 4)</P><P></P><P>As an example:</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">01.test1 would get test1</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Hope this helps!</SPAN></P></BODY></HTML> Thu, 27 Feb 2014 14:06:10 GMT https://community.qlik.com/t5/QlikView/Trim-string/m-p/579126#M215339 jerem1234 2014-02-27T14:06:10Z Re: Trim string https://community.qlik.com/t5/QlikView/Trim-string/m-p/579127#M215340 <HTML><HEAD></HEAD><BODY><P><STRONG>Bjorn</STRONG></P><P></P><P>To remove the first 2 characters use :</P><P></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; mid( [YourField] , 3 )</EM></P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Thu, 27 Feb 2014 14:07:32 GMT https://community.qlik.com/t5/QlikView/Trim-string/m-p/579127#M215340 Anonymous 2014-02-27T14:07:32Z Re: Trim string https://community.qlik.com/t5/QlikView/Trim-string/m-p/579128#M215341 <HTML><HEAD></HEAD><BODY><P>Could also try Subfield(FIELD, '.', 2)</P></BODY></HTML> Thu, 27 Feb 2014 14:07:38 GMT https://community.qlik.com/t5/QlikView/Trim-string/m-p/579128#M215341 jerem1234 2014-02-27T14:07:38Z Re: Trim string https://community.qlik.com/t5/QlikView/Trim-string/m-p/579129#M215342 <HTML><HEAD></HEAD><BODY><P>Another option...</P><P></P><P>=right(YourField, len(YourField)-3)</P></BODY></HTML> Thu, 27 Feb 2014 15:21:34 GMT https://community.qlik.com/t5/QlikView/Trim-string/m-p/579129#M215342 Nicole-Smith 2014-02-27T15:21:34Z Re: Trim string https://community.qlik.com/t5/QlikView/Trim-string/m-p/579130#M215343 <HTML><HEAD></HEAD><BODY><P>You could try SUBFIELD</P><P></P><P><EM>SUBFIELD(YourField,'.',-1)</EM></P></BODY></HTML> Thu, 27 Feb 2014 15:39:40 GMT https://community.qlik.com/t5/QlikView/Trim-string/m-p/579130#M215343 rustyfishbones 2014-02-27T15:39:40Z