https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1947702#M1219622 <P>LOAD Num(Mid(ID,2,2)) as ExpectedOutput</P> <P>FROM ...</P> <P>&nbsp;</P> Fri, 24 Jun 2022 05:22:42 GMT MarcoWedel 2022-06-24T05:22:42Z https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1947696#M1219621 <P>Hi Experts,<BR />Have one ID column (data type is string in Qlik) and want to extract 2nd and 3rd character from it as belows:<BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="U_Waqar_0-1656045973178.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82555iD7DDE4BDA4DD1996/image-size/medium?v=v2&amp;px=400" role="button" title="U_Waqar_0-1656045973178.png" alt="U_Waqar_0-1656045973178.png" /></span></P> <P>I have tried using Subfield but not working as required. Please help.</P> <P>Many Thanks,</P> <P>&nbsp;</P> Fri, 24 Jun 2022 04:49:29 GMT https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1947696#M1219621 U_Waqar 2022-06-24T04:49:29Z https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1947702#M1219622 <P>LOAD Num(Mid(ID,2,2)) as ExpectedOutput</P> <P>FROM ...</P> <P>&nbsp;</P> Fri, 24 Jun 2022 05:22:42 GMT https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1947702#M1219622 MarcoWedel 2022-06-24T05:22:42Z