topic Re: Remove part of a string in QlikView https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366776#M418215 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>What is your expression for the variable vCourseFamily?</P></BODY></HTML> Thu, 04 May 2017 15:48:40 GMT settu_periasamy 2017-05-04T15:48:40Z Remove part of a string https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366775#M418214 <HTML><HEAD></HEAD><BODY><P>Hi I have a string in a variable vCourseFamily 'abc', 'def','hhh' . I want to remove the last part of the string 'hhh' from the string. Kindly suggest.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 04 May 2017 15:44:16 GMT https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366775#M418214 2017-05-04T15:44:16Z Re: Remove part of a string https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366776#M418215 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>What is your expression for the variable vCourseFamily?</P></BODY></HTML> Thu, 04 May 2017 15:48:40 GMT https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366776#M418215 settu_periasamy 2017-05-04T15:48:40Z Re: Remove part of a string https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366777#M418216 <HTML><HEAD></HEAD><BODY><P>=Concat(DISTINCT chr(39)&amp;'*' &amp; [CourseFamily]&amp;chr(39) , ', ')</P></BODY></HTML> Thu, 04 May 2017 15:52:53 GMT https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366777#M418216 2017-05-04T15:52:53Z Re: Remove part of a string https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366778#M418217 <HTML><HEAD></HEAD><BODY><P>do you want to remove the last 3 characters? or it would by dynamic one?</P><P></P><P>Can you just post small qv app with output?</P></BODY></HTML> Thu, 04 May 2017 15:55:48 GMT https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366778#M418217 settu_periasamy 2017-05-04T15:55:48Z Re: Remove part of a string https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366779#M418218 <HTML><HEAD></HEAD><BODY><P>I want any occurrence of the word 'hhh' in the above string to be removed</P></BODY></HTML> Thu, 04 May 2017 15:57:50 GMT https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366779#M418218 2017-05-04T15:57:50Z Re: Remove part of a string https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366780#M418219 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Concat(<SPAN style="color: #ff0000;">{&lt;<SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">CourseFamily -= {'hhh'}</SPAN>&gt;}</SPAN> DISTINCT chr(39)&amp;'*' &amp; [CourseFamily]&amp;chr(39) , ', ')</STRONG></SPAN></P></BODY></HTML> Thu, 04 May 2017 16:00:28 GMT https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366780#M418219 sunny_talwar 2017-05-04T16:00:28Z Re: Remove part of a string https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366781#M418220 <HTML><HEAD></HEAD><BODY><P>In your CONCAT, can you not ignore [CourseFamily] whenever it contains 'hhh' ?</P></BODY></HTML> Thu, 04 May 2017 16:03:21 GMT https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366781#M418220 richard_chilvers 2017-05-04T16:03:21Z Re: Remove part of a string https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366782#M418221 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny!</P></BODY></HTML> Thu, 04 May 2017 16:03:49 GMT https://community.qlik.com/t5/QlikView/Remove-part-of-a-string/m-p/1366782#M418221 2017-05-04T16:03:49Z