topic Re: String search in QlikView https://community.qlik.com/t5/QlikView/String-search/m-p/774610#M1030954 <HTML><HEAD></HEAD><BODY><P>Could you attached your sample?</P></BODY></HTML> Tue, 10 Feb 2015 05:20:13 GMT robert_mika 2015-02-10T05:20:13Z String search https://community.qlik.com/t5/QlikView/String-search/m-p/774608#M1030950 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">In our SQL table, we are importing unstructured notes in one column. I would like to search for 'key word' and surrounding 200 words around key word. Is it possible in Qliview?</SPAN></P></BODY></HTML> Tue, 10 Feb 2015 05:16:17 GMT https://community.qlik.com/t5/QlikView/String-search/m-p/774608#M1030950 2015-02-10T05:16:17Z Re: String search https://community.qlik.com/t5/QlikView/String-search/m-p/774609#M1030952 <HTML><HEAD></HEAD><BODY><P>Check Index(),Match() or WildMatch()</P></BODY></HTML> Tue, 10 Feb 2015 05:18:45 GMT https://community.qlik.com/t5/QlikView/String-search/m-p/774609#M1030952 anbu1984 2015-02-10T05:18:45Z Re: String search https://community.qlik.com/t5/QlikView/String-search/m-p/774610#M1030954 <HTML><HEAD></HEAD><BODY><P>Could you attached your sample?</P></BODY></HTML> Tue, 10 Feb 2015 05:20:13 GMT https://community.qlik.com/t5/QlikView/String-search/m-p/774610#M1030954 robert_mika 2015-02-10T05:20:13Z Re: String search https://community.qlik.com/t5/QlikView/String-search/m-p/774611#M1030955 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>example:</P><P></P><P>IF(WildMatch(AC_4,'*Intercompany*')=1 AND AC_4&lt;&gt;'Subcontracting cost - Other than Intercompany',mid(AC_4,index(AC_4,'-',2)+1,210)) as INTER_COMPNAY&nbsp; </P><P></P><P>The <SPAN class="Bold">match</SPAN> function performs a case sensitive comparison while wildmatch &amp; <SPAN class="Bold">mixmatch</SPAN> function performs a case insensitive comparison. </P></BODY></HTML> Tue, 10 Feb 2015 05:28:57 GMT https://community.qlik.com/t5/QlikView/String-search/m-p/774611#M1030955 sagarkharpude 2015-02-10T05:28:57Z Re: String search https://community.qlik.com/t5/QlikView/String-search/m-p/774612#M1030956 <HTML><HEAD></HEAD><BODY><P>Thank you that helps.</P></BODY></HTML> Thu, 12 Feb 2015 05:05:24 GMT https://community.qlik.com/t5/QlikView/String-search/m-p/774612#M1030956 2015-02-12T05:05:24Z Re: String search https://community.qlik.com/t5/QlikView/String-search/m-p/774613#M1030957 <HTML><HEAD></HEAD><BODY><P>please mark the correct answer and close the thread.</P></BODY></HTML> Thu, 12 Feb 2015 05:18:20 GMT https://community.qlik.com/t5/QlikView/String-search/m-p/774613#M1030957 sagarkharpude 2015-02-12T05:18:20Z