topic Re: SubString value in Water Cooler https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483588#M1472 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>Load&nbsp; Num(KeepChar(Test,'1234567890')) AS Test;</P><P>Load * Inline</P><P>[</P><P>Test</P><P>B0011111</P><P>B0111222</P><P>B010110</P><P>];</P></BODY></HTML> Mon, 12 Aug 2013 08:06:48 GMT MayilVahanan 2013-08-12T08:06:48Z SubString value https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483587#M1471 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find the scenario below.</P><P></P><P>There is a field contains the following values</P><P></P><P>B0011111</P><P>B0111222</P><P>B0101101</P><P></P><P>I need the output as below.</P><P></P><P>11111</P><P>111222</P><P>101101</P><P></P><P>Any one can help on this?</P></BODY></HTML> Mon, 12 Aug 2013 07:56:06 GMT https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483587#M1471 2013-08-12T07:56:06Z Re: SubString value https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483588#M1472 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>Load&nbsp; Num(KeepChar(Test,'1234567890')) AS Test;</P><P>Load * Inline</P><P>[</P><P>Test</P><P>B0011111</P><P>B0111222</P><P>B010110</P><P>];</P></BODY></HTML> Mon, 12 Aug 2013 08:06:48 GMT https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483588#M1472 MayilVahanan 2013-08-12T08:06:48Z Re: SubString value https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483589#M1473 <HTML><HEAD></HEAD><BODY><P>try mid('fieldname',1) </P><P></P><P></P><P>or 2</P></BODY></HTML> Mon, 12 Aug 2013 08:15:42 GMT https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483589#M1473 2013-08-12T08:15:42Z Re: SubString value https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483590#M1474 <HTML><HEAD></HEAD><BODY><P>This should work for you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P><SPAN class="Bold">Mid(<SPAN class="Italic">FieldName, </SPAN>FindOneOf(</SPAN><SPAN class="Italic">FieldName,'123456789'))</SPAN></P></BODY></HTML> Mon, 12 Aug 2013 08:38:34 GMT https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483590#M1474 jfkinspari 2013-08-12T08:38:34Z Re: SubString value https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483591#M1475 <HTML><HEAD></HEAD><BODY><P>Thanks it's works. <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P></BODY></HTML> Mon, 12 Aug 2013 08:56:03 GMT https://community.qlik.com/t5/Water-Cooler/SubString-value/m-p/483591#M1475 2013-08-12T08:56:03Z