topic Re: Extract the two fiels from a field in QlikView https://community.qlik.com/t5/QlikView/Extract-the-two-fiels-from-a-field/m-p/1210033#M388269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution might be:</P><P></P><P><IMG alt="QlikCommunity_Thread_238799_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143071_QlikCommunity_Thread_238799_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14784685715966112 jive_text_macro" jivemacro_uid="_14784685715966112"> <P>LOAD *,</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; Mid(Code,5,2)as SubCode</P> <P>Inline [</P> <P>Code</P> <P>20161099</P> <P>20171100</P> <P>20181201</P> <P>20191302</P> <P>];</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 06 Nov 2016 21:39:32 GMT MarcoWedel 2016-11-06T21:39:32Z Extract the two fiels from a field https://community.qlik.com/t5/QlikView/Extract-the-two-fiels-from-a-field/m-p/1210032#M388268 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have this code&nbsp; 20161099 and I want to extract the position 5 and 6 "10" in load script.</P><P></P><P>Many thank's</P><P></P><P>Eduard</P></BODY></HTML> Sun, 06 Nov 2016 21:10:35 GMT https://community.qlik.com/t5/QlikView/Extract-the-two-fiels-from-a-field/m-p/1210032#M388268 ecabanas 2016-11-06T21:10:35Z Re: Extract the two fiels from a field https://community.qlik.com/t5/QlikView/Extract-the-two-fiels-from-a-field/m-p/1210033#M388269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution might be:</P><P></P><P><IMG alt="QlikCommunity_Thread_238799_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143071_QlikCommunity_Thread_238799_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14784685715966112 jive_text_macro" jivemacro_uid="_14784685715966112"> <P>LOAD *,</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; Mid(Code,5,2)as SubCode</P> <P>Inline [</P> <P>Code</P> <P>20161099</P> <P>20171100</P> <P>20181201</P> <P>20191302</P> <P>];</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 06 Nov 2016 21:39:32 GMT https://community.qlik.com/t5/QlikView/Extract-the-two-fiels-from-a-field/m-p/1210033#M388269 MarcoWedel 2016-11-06T21:39:32Z