topic How can I split 15 digit numeric number?? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416849#M154954 <HTML><HEAD></HEAD><BODY><P>How can I split 15 digit numeric number??</P><P>eg.234879345798375</P><P>I want '457' from this number.It is available after 7th digit in number.(required '3' digit after 7th digit)</P></BODY></HTML> Wed, 29 May 2013 05:44:21 GMT 2013-05-29T05:44:21Z How can I split 15 digit numeric number?? https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416849#M154954 <HTML><HEAD></HEAD><BODY><P>How can I split 15 digit numeric number??</P><P>eg.234879345798375</P><P>I want '457' from this number.It is available after 7th digit in number.(required '3' digit after 7th digit)</P></BODY></HTML> Wed, 29 May 2013 05:44:21 GMT https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416849#M154954 2013-05-29T05:44:21Z Re: How can I split 15 digit numeric number?? https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416850#M154955 <HTML><HEAD></HEAD><BODY><P>use : <SPAN class="Code"><STRONG>mid</STRONG>('yourstring',8, 3 )</SPAN> .</P><P></P><P></P><P>Thanks. </P></BODY></HTML> Wed, 29 May 2013 05:48:11 GMT https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416850#M154955 tresB 2013-05-29T05:48:11Z Re: How can I split 15 digit numeric number?? https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416851#M154956 <HTML><HEAD></HEAD><BODY><P>num#(mid(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">234879345798375</SPAN>,8,3))</P></BODY></HTML> Wed, 29 May 2013 05:48:52 GMT https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416851#M154956 Gysbert_Wassenaar 2013-05-29T05:48:52Z Re: How can I split 15 digit numeric number?? https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416852#M154957 <HTML><HEAD></HEAD><BODY><P>use this</P><P><SPAN class="Code">mid('abcdef',3, 2 )</SPAN> returns <SPAN class="Italic">'cd'</SPAN>. </P><P></P><P>or</P><P></P><P>=mid('234879345798375',8,3)</P></BODY></HTML> Wed, 29 May 2013 05:50:35 GMT https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416852#M154957 2013-05-29T05:50:35Z Re: How can I split 15 digit numeric number?? https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416853#M154958 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P>can you tell me the difference of "num" and "num#". I can't see any difference when I compare the 2 commands in Help.</P><P></P><P>Sorry for talking OT. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P>Regards,</P><P></P><P>Peter</P></BODY></HTML> Wed, 29 May 2013 07:50:07 GMT https://community.qlik.com/t5/QlikView/How-can-I-split-15-digit-numeric-number/m-p/416853#M154958 peschu123 2013-05-29T07:50:07Z