topic Find Text in String in QlikView https://community.qlik.com/t5/QlikView/Find-Text-in-String/m-p/1172109#M885890 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the text <STRONG>ABC</STRONG>.</P><P></P><P>I want to know if <STRONG>ABC</STRONG> is in the following String: DEF, CBX, <SPAN style="text-decoration: underline;">ABC</SPAN>, RST, DPF.</P><P></P><P>Do you know how could I do that in a Text Object?</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT microwin88x 2020-11-25T16:16:04Z Find Text in String https://community.qlik.com/t5/QlikView/Find-Text-in-String/m-p/1172109#M885890 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the text <STRONG>ABC</STRONG>.</P><P></P><P>I want to know if <STRONG>ABC</STRONG> is in the following String: DEF, CBX, <SPAN style="text-decoration: underline;">ABC</SPAN>, RST, DPF.</P><P></P><P>Do you know how could I do that in a Text Object?</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Find-Text-in-String/m-p/1172109#M885890 microwin88x 2020-11-25T16:16:04Z Re: Find Text in String https://community.qlik.com/t5/QlikView/Find-Text-in-String/m-p/1172110#M885891 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P><STRONG>=If(SubStringCount(YourString, 'ABC') &gt;= 1, 1)</STRONG></P></BODY></HTML> Thu, 08 Sep 2016 17:52:07 GMT https://community.qlik.com/t5/QlikView/Find-Text-in-String/m-p/1172110#M885891 sunny_talwar 2016-09-08T17:52:07Z Re: Find Text in String https://community.qlik.com/t5/QlikView/Find-Text-in-String/m-p/1172111#M885892 <HTML><HEAD></HEAD><BODY><P>=Mid('DEF, CBX, ABC, RST, DPF',Index('DEF, CBX, ABC, RST, DPF','ABC'),3)</P></BODY></HTML> Thu, 08 Sep 2016 17:55:38 GMT https://community.qlik.com/t5/QlikView/Find-Text-in-String/m-p/1172111#M885892 jpenuliar 2016-09-08T17:55:38Z