topic Re: Excel Special Character Issue in QlikView https://community.qlik.com/t5/QlikView/Excel-Special-Character-Issue/m-p/744936#M265948 <HTML><HEAD></HEAD><BODY><P>how about the replace function to replace the value with an empty string ? </P><P></P><P><SPAN class="Bold">Replace( Field</SPAN><SPAN class="Italic">, '_x000D_'&nbsp; ,''</SPAN><SPAN class="Bold">)</SPAN></P><P><SPAN class="Bold"><BR /></SPAN></P><P><SPAN class="Bold"><BR /></SPAN></P></BODY></HTML> Wed, 04 Mar 2015 18:07:28 GMT JonnyPoole 2015-03-04T18:07:28Z Excel Special Character Issue https://community.qlik.com/t5/QlikView/Excel-Special-Character-Issue/m-p/744935#M265947 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>All new lines entries in Excel are appended with a special character "_x000D_". Is there a way to get rid of this in qlikview.</P><P></P><P>Thanks,</P><P>Abhay Sudhakaran</P></BODY></HTML> Wed, 04 Mar 2015 17:52:44 GMT https://community.qlik.com/t5/QlikView/Excel-Special-Character-Issue/m-p/744935#M265947 Anonymous 2015-03-04T17:52:44Z Re: Excel Special Character Issue https://community.qlik.com/t5/QlikView/Excel-Special-Character-Issue/m-p/744936#M265948 <HTML><HEAD></HEAD><BODY><P>how about the replace function to replace the value with an empty string ? </P><P></P><P><SPAN class="Bold">Replace( Field</SPAN><SPAN class="Italic">, '_x000D_'&nbsp; ,''</SPAN><SPAN class="Bold">)</SPAN></P><P><SPAN class="Bold"><BR /></SPAN></P><P><SPAN class="Bold"><BR /></SPAN></P></BODY></HTML> Wed, 04 Mar 2015 18:07:28 GMT https://community.qlik.com/t5/QlikView/Excel-Special-Character-Issue/m-p/744936#M265948 JonnyPoole 2015-03-04T18:07:28Z