topic Re: Cut string value - start from forth position. in QlikView https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26912#M791339 <HTML><HEAD></HEAD><BODY><P>Try this,</P><P></P><P>Load Field as Original, Right(Field,Len(Field)-3) as Newfield</P><P>From xyz;</P><P></P><P>Update:</P><P>You can als0 use the Mid function.</P><P></P><P>Mid(Field,4,Len(Field)-3)</P><P></P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 31 Jan 2018 11:02:19 GMT kaushiknsolanki 2018-01-31T11:02:19Z Cut string value - start from forth position. https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26911#M791338 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have values like this:</P><P></P><P>99915986</P><P>999547</P><P>9998655</P><P></P><P>I need to cut first three positions, so my values will be:</P><P>15986</P><P>547</P><P>8655</P><P> Can someone help me with the code?</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26911#M791338 retko1985 2020-11-25T16:16:04Z Re: Cut string value - start from forth position. https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26912#M791339 <HTML><HEAD></HEAD><BODY><P>Try this,</P><P></P><P>Load Field as Original, Right(Field,Len(Field)-3) as Newfield</P><P>From xyz;</P><P></P><P>Update:</P><P>You can als0 use the Mid function.</P><P></P><P>Mid(Field,4,Len(Field)-3)</P><P></P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 31 Jan 2018 11:02:19 GMT https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26912#M791339 kaushiknsolanki 2018-01-31T11:02:19Z Re: Cut string value - start from forth position. https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26913#M791340 <HTML><HEAD></HEAD><BODY><P>Or simply:</P><P></P><P><STRONG>Mid(String, 4)</STRONG></P></BODY></HTML> Wed, 31 Jan 2018 11:07:21 GMT https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26913#M791340 tresB 2018-01-31T11:07:21Z Re: Cut string value - start from forth position. https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26914#M791341 <HTML><HEAD></HEAD><BODY><P>=mid(999547,4)</P></BODY></HTML> Wed, 31 Jan 2018 12:16:00 GMT https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26914#M791341 shiveshsingh 2018-01-31T12:16:00Z Re: Cut string value - start from forth position. https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26915#M791342 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Mid(Fieldname,4,Len(Fieldname)-3)</SPAN></P></BODY></HTML> Wed, 31 Jan 2018 12:40:40 GMT https://community.qlik.com/t5/QlikView/Cut-string-value-start-from-forth-position/m-p/26915#M791342 qlik4asif 2018-01-31T12:40:40Z