topic Re: Cutting a String in QlikView https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797066#M281571 <HTML><HEAD></HEAD><BODY><P>SubField(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">invoice_number_numeric,'-',-1) //-1 retrieves last field</SPAN></P></BODY></HTML> Fri, 21 Nov 2014 11:14:47 GMT anbu1984 2014-11-21T11:14:47Z Cutting a String https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797063#M281568 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm trying to get the last bit of a string out, but I'm not doing it right!</P><P></P><P>This is my string and couple of examples:</P><P></P><P>100-ARINVK-13296910</P><P>029-ARINV-10816695</P><P></P><P>I need to get the numbers after the second '-'. So in the example above, this would be:</P><P></P><P>13296910</P><P>10816695</P><P></P><P>I've tried this:</P><P></P><TABLE><TBODY><TR><TD>&nbsp;&nbsp;&nbsp; Mid(Index("invoice_number_numeric",'-',2),8)</TD><TD></TD><TD>as InvoiceNo2</TD></TR></TBODY></TABLE><P></P><P>But it's not pulling it through.</P><P></P><P>What am I doing wrong?</P><P></P><P>I'm a newbie to this, so any help is appreciated!</P><P></P><P>Di</P></BODY></HTML> Fri, 21 Nov 2014 11:07:49 GMT https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797063#M281568 dinicholls 2014-11-21T11:07:49Z Re: Cutting a String https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797064#M281569 <HTML><HEAD></HEAD><BODY><P>try </P><P></P><P>Right(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333339691162px;">invoice_number_numeric, <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span></SPAN></P></BODY></HTML> Fri, 21 Nov 2014 11:09:44 GMT https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797064#M281569 alexandros17 2014-11-21T11:09:44Z Re: Cutting a String https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797065#M281570 <HTML><HEAD></HEAD><BODY><P>Try like this..</P><P></P><P>SubField(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">invoice_number_numeric,'-',3)</SPAN></P></BODY></HTML> Fri, 21 Nov 2014 11:12:54 GMT https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797065#M281570 PradeepReddy 2014-11-21T11:12:54Z Re: Cutting a String https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797066#M281571 <HTML><HEAD></HEAD><BODY><P>SubField(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">invoice_number_numeric,'-',-1) //-1 retrieves last field</SPAN></P></BODY></HTML> Fri, 21 Nov 2014 11:14:47 GMT https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797066#M281571 anbu1984 2014-11-21T11:14:47Z Re: Cutting a String https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797067#M281572 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P> Pradeeps solution seems to me the best one. add 'as InvoiceNo2' to it, and it should work in all instances.</P></BODY></HTML> Fri, 21 Nov 2014 11:17:47 GMT https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797067#M281572 puttemans 2014-11-21T11:17:47Z Re: Cutting a String https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797068#M281573 <HTML><HEAD></HEAD><BODY><P>Mid(<STRONG>invoice_number_numeric,</STRONG>Index(invoice_number_numeric,'-',2)<STRONG>+1</STRONG>,8) as InvoiceNo2</P></BODY></HTML> Fri, 21 Nov 2014 11:19:37 GMT https://community.qlik.com/t5/QlikView/Cutting-a-String/m-p/797068#M281573 anbu1984 2014-11-21T11:19:37Z