topic Re: Extract the required string using string functions in QlikView https://community.qlik.com/t5/QlikView/Extract-the-required-string-using-string-functions/m-p/1034160#M348806 <HTML><HEAD></HEAD><BODY><P>You can use <STRONG>TextBetween</STRONG> or <STRONG>MID</STRONG> functions</P></BODY></HTML> Wed, 03 Feb 2016 02:08:40 GMT 2016-02-03T02:08:40Z Extract the required string using string functions https://community.qlik.com/t5/QlikView/Extract-the-required-string-using-string-functions/m-p/1034157#M348803 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can someone help me in getting the desired string from below text in bold</P><P></P><P>Input Example: <STRONG>Q68. Behavioral Health Screening:</STRONG></P><P></P><P>I need the output as </P><P></P><P><STRONG>Behavioral Health Screening</STRONG></P><P></P><P>Thanks</P><P>Satish</P></BODY></HTML> Tue, 02 Feb 2016 21:52:32 GMT https://community.qlik.com/t5/QlikView/Extract-the-required-string-using-string-functions/m-p/1034157#M348803 satishkurra 2016-02-02T21:52:32Z Re: Extract the required string using string functions https://community.qlik.com/t5/QlikView/Extract-the-required-string-using-string-functions/m-p/1034158#M348804 <HTML><HEAD></HEAD><BODY><P>You can use these functions like this:</P><P></P><P>Trim( TextBetween( Txt , '.' , ':' ) )</P></BODY></HTML> Tue, 02 Feb 2016 22:16:33 GMT https://community.qlik.com/t5/QlikView/Extract-the-required-string-using-string-functions/m-p/1034158#M348804 petter 2016-02-02T22:16:33Z Re: Extract the required string using string functions https://community.qlik.com/t5/QlikView/Extract-the-required-string-using-string-functions/m-p/1034159#M348805 <HTML><HEAD></HEAD><BODY><P>Thanks . It worked...</P></BODY></HTML> Tue, 02 Feb 2016 22:25:42 GMT https://community.qlik.com/t5/QlikView/Extract-the-required-string-using-string-functions/m-p/1034159#M348805 satishkurra 2016-02-02T22:25:42Z Re: Extract the required string using string functions https://community.qlik.com/t5/QlikView/Extract-the-required-string-using-string-functions/m-p/1034160#M348806 <HTML><HEAD></HEAD><BODY><P>You can use <STRONG>TextBetween</STRONG> or <STRONG>MID</STRONG> functions</P></BODY></HTML> Wed, 03 Feb 2016 02:08:40 GMT https://community.qlik.com/t5/QlikView/Extract-the-required-string-using-string-functions/m-p/1034160#M348806 2016-02-03T02:08:40Z