topic getting data out of a string in QlikView https://community.qlik.com/t5/QlikView/getting-data-out-of-a-string/m-p/302734#M1193105 <HTML><HEAD></HEAD><BODY><P>Hi Daniel,</P><P></P><P>try <EM>mid(Endtime_Bon,12,8)</EM></P><P></P><P></P><P>Alex</P></BODY></HTML> Mon, 25 Jul 2011 08:58:40 GMT 2011-07-25T08:58:40Z getting data out of a string https://community.qlik.com/t5/QlikView/getting-data-out-of-a-string/m-p/302733#M1193104 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>in my Qvw-Document is an field named "Endtime_Bon".</P><P>The content of this field looks like this:</P><P>2011-01-02T13:28:32-1:00</P><P></P><P>How can I grab only the Time "13:28:32" by using a formular?</P><P>or is there a better way to get the data?</P><P></P><P>greetings</P><P>daniel</P></BODY></HTML> Mon, 25 Jul 2011 07:48:18 GMT https://community.qlik.com/t5/QlikView/getting-data-out-of-a-string/m-p/302733#M1193104 2011-07-25T07:48:18Z getting data out of a string https://community.qlik.com/t5/QlikView/getting-data-out-of-a-string/m-p/302734#M1193105 <HTML><HEAD></HEAD><BODY><P>Hi Daniel,</P><P></P><P>try <EM>mid(Endtime_Bon,12,8)</EM></P><P></P><P></P><P>Alex</P></BODY></HTML> Mon, 25 Jul 2011 08:58:40 GMT https://community.qlik.com/t5/QlikView/getting-data-out-of-a-string/m-p/302734#M1193105 2011-07-25T08:58:40Z getting data out of a string https://community.qlik.com/t5/QlikView/getting-data-out-of-a-string/m-p/302735#M1193106 <HTML><HEAD></HEAD><BODY><P> Thank you alex,</P><P></P><P>it works fine <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Mon, 25 Jul 2011 10:49:20 GMT https://community.qlik.com/t5/QlikView/getting-data-out-of-a-string/m-p/302735#M1193106 2011-07-25T10:49:20Z