topic Re: Extract second character from a field in QlikView https://community.qlik.com/t5/QlikView/Extract-second-character-from-a-field/m-p/698003#M252077 <HTML><HEAD></HEAD><BODY><P>Mid(Field,2,1)</P></BODY></HTML> Thu, 17 Jul 2014 12:17:40 GMT alexandros17 2014-07-17T12:17:40Z Extract second character from a field https://community.qlik.com/t5/QlikView/Extract-second-character-from-a-field/m-p/698002#M252076 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Do you know how to extract the second character from a field ?</P><P></P><P>I tried with :</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P><STRONG>left(FIELD,2) as Result</STRONG></P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>But it give the two first, I need only the second.</P><P></P><P>Thanks for your help ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 17 Jul 2014 12:15:36 GMT https://community.qlik.com/t5/QlikView/Extract-second-character-from-a-field/m-p/698002#M252076 2014-07-17T12:15:36Z Re: Extract second character from a field https://community.qlik.com/t5/QlikView/Extract-second-character-from-a-field/m-p/698003#M252077 <HTML><HEAD></HEAD><BODY><P>Mid(Field,2,1)</P></BODY></HTML> Thu, 17 Jul 2014 12:17:40 GMT https://community.qlik.com/t5/QlikView/Extract-second-character-from-a-field/m-p/698003#M252077 alexandros17 2014-07-17T12:17:40Z Re: Extract second character from a field https://community.qlik.com/t5/QlikView/Extract-second-character-from-a-field/m-p/698004#M252078 <HTML><HEAD></HEAD><BODY><P>Yo can use below</P><P></P><P>=mid('ashfaq',2,1)</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 17 Jul 2014 12:19:05 GMT https://community.qlik.com/t5/QlikView/Extract-second-character-from-a-field/m-p/698004#M252078 ashfaq_haseeb 2014-07-17T12:19:05Z Re: Extract second character from a field https://community.qlik.com/t5/QlikView/Extract-second-character-from-a-field/m-p/698005#M252079 <HTML><HEAD></HEAD><BODY><P>Thanks to both of you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Thu, 17 Jul 2014 12:20:45 GMT https://community.qlik.com/t5/QlikView/Extract-second-character-from-a-field/m-p/698005#M252079 2014-07-17T12:20:45Z