topic Re: How to remove the data with special character? in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382215#M421198 <HTML><HEAD></HEAD><BODY><P>Thanks Shradhha,</P><P>I got the answer</P></BODY></HTML> Tue, 17 Oct 2017 12:18:07 GMT Anonymous 2017-10-17T12:18:07Z How to remove the data with special character? https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382206#M421189 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have sample data for Product Id </P><P></P><P>Product Id</P><P>A02</P><P>A02-101</P><P>A02-102</P><P>A02-104</P><P>A03</P><P>A04</P><P>A05</P><P>A05-101</P><P>A05-103</P><P>A06</P><P>A06-101</P><P>A06-102</P><P>A07 </P><P></P><P>How I remove all data which is present with special character '-'.</P><P></P><P>Expected output -</P><P>Product Id</P><P>A02</P><P>A03</P><P>A04</P><P>A05</P><P>A06</P><P>A07 </P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 17 Oct 2017 11:39:34 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382206#M421189 Anonymous 2017-10-17T11:39:34Z Re: How to remove the data with special character? https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382207#M421190 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P>LOAD SubField(Field, '-', 1) as Field Inline [</P><P>Field</P><P>A02</P><P>A02-101</P><P>A02-102</P><P>A02-104</P><P>A03</P><P>A04</P><P>A05</P><P>A05-101</P><P>A05-103</P><P>A06</P><P>A06-101</P><P>A06-102</P><P>A07</P><P>];</P></BODY></HTML> Tue, 17 Oct 2017 11:41:38 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382207#M421190 Anil_Babu_Samineni 2017-10-17T11:41:38Z Re: How to remove the data with special character? https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382208#M421191 <HTML><HEAD></HEAD><BODY><P>Hi Anil,</P><P></P><P>Thanks for your quick reply I have already I tried this option but this option not remove data with present with special character&nbsp; </P></BODY></HTML> Tue, 17 Oct 2017 11:46:19 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382208#M421191 Anonymous 2017-10-17T11:46:19Z Re: How to remove the data with special character? https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382209#M421192 <HTML><HEAD></HEAD><BODY><P>Please provide with some special characters too</P></BODY></HTML> Tue, 17 Oct 2017 11:49:59 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382209#M421192 Anil_Babu_Samineni 2017-10-17T11:49:59Z Re: How to remove the data with special character? https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382210#M421193 <HTML><HEAD></HEAD><BODY><P>Hi Anil,</P><P></P><P>I have used same expression data shows without special character but it also capture special character data</P><P>e.g.</P><P>SubField(Product Id, '-', 1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Capture data</P><P>A02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A02</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A02-101</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A02-102</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A02-104</P><P>here SubField() function shows A02 but it capture remaining three code data of special character.</P><P></P><P>I want only&nbsp; A02 product code data</P><P>e.g.</P><P>SubField(Product Id, '-', 1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Capture data </P><P>A02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A02</P><P></P><P>It should not capture other three product data that is my expected output.</P><P>Is the any other solution?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Tue, 17 Oct 2017 12:03:50 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382210#M421193 Anonymous 2017-10-17T12:03:50Z Re: How to remove the data with special character? https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382211#M421194 <HTML><HEAD></HEAD><BODY><P>Are you not looking this?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179920_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 17 Oct 2017 12:09:15 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382211#M421194 Anil_Babu_Samineni 2017-10-17T12:09:15Z Re: How to remove the data with special character? https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382212#M421195 <HTML><HEAD></HEAD><BODY><P>Hi Ishwar,</P><P></P><P>Try:</P><P></P><P>Data:</P><P>LOAD * WHERE Not WildMatch([Product Id],'*-*');</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Product Id</P><P>&nbsp;&nbsp;&nbsp; A02</P><P>&nbsp;&nbsp;&nbsp; A02-101</P><P>&nbsp;&nbsp;&nbsp; A02-102</P><P>&nbsp;&nbsp;&nbsp; A02-104</P><P>&nbsp;&nbsp;&nbsp; A03</P><P>&nbsp;&nbsp;&nbsp; A04</P><P>&nbsp;&nbsp;&nbsp; A05</P><P>&nbsp;&nbsp;&nbsp; A05-101</P><P>&nbsp;&nbsp;&nbsp; A05-103</P><P>&nbsp;&nbsp;&nbsp; A06</P><P>&nbsp;&nbsp;&nbsp; A06-101</P><P>&nbsp;&nbsp;&nbsp; A06-102</P><P>&nbsp;&nbsp;&nbsp; A07</P><P>];</P><P></P><P>Giving</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Product Id</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A03</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A04</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A05</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A06</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">A07</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>Regards</P><P></P><P>Andrew</P></BODY></HTML> Tue, 17 Oct 2017 12:09:19 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382212#M421195 effinty2112 2017-10-17T12:09:19Z Re: How to remove the data with special character? https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382213#M421196 <HTML><HEAD></HEAD><BODY><P>Try these condition while loading data</P><P></P><P>where Len([Product Id]) =3</P><P></P><P>else</P><P></P><P>where not wildmatch([Product Id],'*-*')</P></BODY></HTML> Tue, 17 Oct 2017 12:10:43 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382213#M421196 shraddha_g 2017-10-17T12:10:43Z Re: How to remove the data with special character? https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382214#M421197 <HTML><HEAD></HEAD><BODY><P>Hi Andrew,</P><P></P><P>I used your&nbsp; solution and&nbsp; I got answer.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 17 Oct 2017 12:17:20 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382214#M421197 Anonymous 2017-10-17T12:17:20Z Re: How to remove the data with special character? https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382215#M421198 <HTML><HEAD></HEAD><BODY><P>Thanks Shradhha,</P><P>I got the answer</P></BODY></HTML> Tue, 17 Oct 2017 12:18:07 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-data-with-special-character/m-p/1382215#M421198 Anonymous 2017-10-17T12:18:07Z