topic Re: remove newline character in QlikView https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560178#M209078 <HTML><HEAD></HEAD><BODY><P>replace(YourField,chr(10),'')&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Chr() not Char() , did you write that correctly? </P></BODY></HTML> Mon, 02 Sep 2013 11:00:18 GMT tresB 2013-09-02T11:00:18Z remove newline character https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560176#M209076 <HTML><HEAD></HEAD><BODY><P>How to delete a new line character from a column in Qlikview</P><P>Some Users have entered Enter in Description column. How do i remove them now. I tried replace(Description',char(10),'')</P><P>but didnt work...</P></BODY></HTML> Mon, 02 Sep 2013 10:15:39 GMT https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560176#M209076 2013-09-02T10:15:39Z Re: remove newline character https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560177#M209077 <HTML><HEAD></HEAD><BODY><P>Can u explain in details what you want to achieve ?</P></BODY></HTML> Mon, 02 Sep 2013 10:54:12 GMT https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560177#M209077 vikasmahajan 2013-09-02T10:54:12Z Re: remove newline character https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560178#M209078 <HTML><HEAD></HEAD><BODY><P>replace(YourField,chr(10),'')&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Chr() not Char() , did you write that correctly? </P></BODY></HTML> Mon, 02 Sep 2013 11:00:18 GMT https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560178#M209078 tresB 2013-09-02T11:00:18Z Re: remove newline character https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560179#M209079 <HTML><HEAD></HEAD><BODY><P>You may need to strip chr(13) too: replace(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">replace(Description,chr(10),''),chr(13),'')</SPAN></P></BODY></HTML> Wed, 04 Sep 2013 17:46:33 GMT https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560179#M209079 Gysbert_Wassenaar 2013-09-04T17:46:33Z Re: remove newline character https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560180#M209080 <HTML><HEAD></HEAD><BODY><P>use&nbsp; purgechar(FieldName,CHR(10)) AS FieldName,</P></BODY></HTML> Wed, 28 Jun 2017 06:57:04 GMT https://community.qlik.com/t5/QlikView/remove-newline-character/m-p/560180#M209080 bwohletz 2017-06-28T06:57:04Z