topic Re: Remove characters between brackets in a string in QlikView https://community.qlik.com/t5/QlikView/Remove-characters-between-brackets-in-a-string/m-p/1448397#M807781 <HTML><HEAD></HEAD><BODY><P><STRONG style="color: black; background: white; font-size: 10.0pt; font-family: 'Helvetica',sans-serif;">PurgeChar(<SPAN style="color: #ff0000;">FieldName</SPAN>, '<STRONG style="color: #3d3d3d; background: white; font-size: 10.0pt; font-family: 'Helvetica',sans-serif;">1234567890( )</STRONG>') as <SPAN style="color: #ff0000;">FieldName</SPAN></STRONG></P></BODY></HTML> Fri, 13 Oct 2017 11:08:23 GMT Anonymous 2017-10-13T11:08:23Z Remove characters between brackets in a string https://community.qlik.com/t5/QlikView/Remove-characters-between-brackets-in-a-string/m-p/1448395#M807779 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to remove characters from field&nbsp; that appear in brackets.</P><P></P><P>Product_A-(01)</P><P>Product_A-(02)</P><P>Product_A_Blue-(01)</P><P><SPAN style="font-size: 13.3333px;">Product_A_Blue-(02)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Should appear as;</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;">Product_A-</P><P style="font-size: 13.3333px;">Product_A_Blue-</P><P style="font-size: 13.3333px;"></P><P><SPAN style="font-size: 13.3333px;">Can anyone help with this?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks</SPAN></P><P><SPAN style="font-size: 13.3333px;">Danny<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Remove-characters-between-brackets-in-a-string/m-p/1448395#M807779 2020-11-25T16:16:04Z Re: Remove characters between brackets in a string https://community.qlik.com/t5/QlikView/Remove-characters-between-brackets-in-a-string/m-p/1448396#M807780 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'courier new', courier;">=Left(Product, Index(Product, '(')-1)</SPAN></P></BODY></HTML> Fri, 13 Oct 2017 11:06:53 GMT https://community.qlik.com/t5/QlikView/Remove-characters-between-brackets-in-a-string/m-p/1448396#M807780 Peter_Cammaert 2017-10-13T11:06:53Z Re: Remove characters between brackets in a string https://community.qlik.com/t5/QlikView/Remove-characters-between-brackets-in-a-string/m-p/1448397#M807781 <HTML><HEAD></HEAD><BODY><P><STRONG style="color: black; background: white; font-size: 10.0pt; font-family: 'Helvetica',sans-serif;">PurgeChar(<SPAN style="color: #ff0000;">FieldName</SPAN>, '<STRONG style="color: #3d3d3d; background: white; font-size: 10.0pt; font-family: 'Helvetica',sans-serif;">1234567890( )</STRONG>') as <SPAN style="color: #ff0000;">FieldName</SPAN></STRONG></P></BODY></HTML> Fri, 13 Oct 2017 11:08:23 GMT https://community.qlik.com/t5/QlikView/Remove-characters-between-brackets-in-a-string/m-p/1448397#M807781 Anonymous 2017-10-13T11:08:23Z Re: Remove characters between brackets in a string https://community.qlik.com/t5/QlikView/Remove-characters-between-brackets-in-a-string/m-p/1448398#M807782 <HTML><HEAD></HEAD><BODY><P>Perfect! Thanks!</P></BODY></HTML> Fri, 13 Oct 2017 11:12:05 GMT https://community.qlik.com/t5/QlikView/Remove-characters-between-brackets-in-a-string/m-p/1448398#M807782 2017-10-13T11:12:05Z