topic Substring in QlikView https://community.qlik.com/t5/QlikView/Substring/m-p/157377#M32884 <HTML><HEAD></HEAD><BODY><P>You can use left(FieldName, 1) and load it as new field name.</P></BODY></HTML> Fri, 11 Mar 2011 20:00:02 GMT disqr_rm 2011-03-11T20:00:02Z Substring https://community.qlik.com/t5/QlikView/Substring/m-p/157376#M32883 <HTML><HEAD></HEAD><BODY><P>Need to pull text from a text filed in specific position. For Example, I would like to select the first position from field 1 where the text in the filed is 10 positions and it's content look like: ABBPTZZZZZ</P><P>I only want to select the "A"</P><P></P><P>Thanx</P></BODY></HTML> Fri, 11 Mar 2011 19:49:05 GMT https://community.qlik.com/t5/QlikView/Substring/m-p/157376#M32883 2011-03-11T19:49:05Z Substring https://community.qlik.com/t5/QlikView/Substring/m-p/157377#M32884 <HTML><HEAD></HEAD><BODY><P>You can use left(FieldName, 1) and load it as new field name.</P></BODY></HTML> Fri, 11 Mar 2011 20:00:02 GMT https://community.qlik.com/t5/QlikView/Substring/m-p/157377#M32884 disqr_rm 2011-03-11T20:00:02Z Substring https://community.qlik.com/t5/QlikView/Substring/m-p/157378#M32885 <HTML><HEAD></HEAD><BODY><P>Thank you for the quick reply. It almost answers my issue. What is the syntax to substring out other positions not just the first, for Example if I want to select the fifth position?</P></BODY></HTML> Fri, 11 Mar 2011 20:10:21 GMT https://community.qlik.com/t5/QlikView/Substring/m-p/157378#M32885 2011-03-11T20:10:21Z Substring https://community.qlik.com/t5/QlikView/Substring/m-p/157379#M32886 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Mid() will do:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Mid('ABCDEF', 2, 3) // "BCD" starting on 2, 3 chars.</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps.</P></BODY></HTML> Fri, 11 Mar 2011 20:25:27 GMT https://community.qlik.com/t5/QlikView/Substring/m-p/157379#M32886 Miguel_Angel_Baeyens 2011-03-11T20:25:27Z