topic Re: Index in QlikView https://community.qlik.com/t5/QlikView/Index/m-p/352665#M1177026 <HTML><HEAD></HEAD><BODY><P>Thank Swuehl!!&nbsp; Thank Celambarasan!!.</P></BODY></HTML> Wed, 14 Mar 2012 14:10:08 GMT 2012-03-14T14:10:08Z Index https://community.qlik.com/t5/QlikView/Index/m-p/352662#M1177023 <HTML><HEAD></HEAD><BODY><P>Hi!.</P><P></P><P>I need extract a character in a field. All the fields that contain ".qvw" extract previous character. </P><P></P><P>Example:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 355px;"><TBODY><TR><TD class="xl63" height="17" width="303"><P>Log</P></TD><TD class="xl63" style="border-left: medium none;" width="52"><P>I need</P></TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;">car_bt_avaya_split_6.qvw.log</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;">car_bt_avaya_split_6.qvw.log</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;">car_lk_tie_dia_7.qvw.log</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">7</TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;">sistema.log</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">-</TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;">sistema.log</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">-</TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;">car_gir_1_1.qvw.log</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">1</TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;">sistema.log</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">-</TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;">car_bt_evento_4.qvw.log</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">4</TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;">car_bt_evento_4.qvw.log</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">4</TD></TR></TBODY></TABLE><P></P><P>I trying with Index funtion but i did not succeed. </P><P></P><P>Can they help me?</P><P></P><P>Thank!!!</P><P></P><P>Ivan. </P></BODY></HTML> Wed, 14 Mar 2012 13:40:32 GMT https://community.qlik.com/t5/QlikView/Index/m-p/352662#M1177023 2012-03-14T13:40:32Z Index https://community.qlik.com/t5/QlikView/Index/m-p/352663#M1177024 <HTML><HEAD></HEAD><BODY><P>Try a combination of index and mid functions:</P><P></P><P>LOAD Log, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [I need],</P><P>&nbsp;&nbsp;&nbsp; <STRONG> mid(Log,index(Log,'.qvw')-1,1) as Wanted</STRONG></P><P>FROM</P><P><SPAN>[</SPAN><A class="jive-link-external-small" href="http://community.qlik.com/thread/49231?tstart=0">http://community.qlik.com/thread/49231?tstart=0</A><SPAN>]</SPAN></P><P>(html, codepage is 1252, embedded labels, table is @1);</P></BODY></HTML> Wed, 14 Mar 2012 13:58:27 GMT https://community.qlik.com/t5/QlikView/Index/m-p/352663#M1177024 swuehl 2012-03-14T13:58:27Z Index https://community.qlik.com/t5/QlikView/Index/m-p/352664#M1177025 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; =Mid(Log,Index(Log,'.qvw')-1,1)</P><P></P><P>Hope it helps</P><P>Celambarasan</P></BODY></HTML> Wed, 14 Mar 2012 14:01:40 GMT https://community.qlik.com/t5/QlikView/Index/m-p/352664#M1177025 CELAMBARASAN 2012-03-14T14:01:40Z Re: Index https://community.qlik.com/t5/QlikView/Index/m-p/352665#M1177026 <HTML><HEAD></HEAD><BODY><P>Thank Swuehl!!&nbsp; Thank Celambarasan!!.</P></BODY></HTML> Wed, 14 Mar 2012 14:10:08 GMT https://community.qlik.com/t5/QlikView/Index/m-p/352665#M1177026 2012-03-14T14:10:08Z