topic Remove carriage return in QlikView https://community.qlik.com/t5/QlikView/Remove-carriage-return/m-p/477721#M178445 <HTML><HEAD></HEAD><BODY><P>I have some data in excel</P><P>as</P><P></P><TABLE border="0" cellspacing="0" frame="VOID" rules="NONE"><TBODY><TR><TD height="34" width="170">COMPLETE<BR />ECR-0001479</TD></TR><TR><TD height="34">COMPLETE<BR />ECR-0002435</TD></TR><TR><TD height="34">COMPLETE<BR />ECR-0002780</TD></TR><TR><TD height="34">COMPLETE<BR />ECR-0003223</TD></TR><TR><TD height="34">COMPLETE<BR />ECR-0003670</TD></TR></TBODY></TABLE><P>where there is carriage return(Alt+enter) in the values.</P><P></P><P>Any idea how to remove it via subfield.....</P><P></P><P>Regards</P><P>Nitin</P></BODY></HTML> Thu, 12 Dec 2013 12:34:30 GMT Anonymous 2013-12-12T12:34:30Z Remove carriage return https://community.qlik.com/t5/QlikView/Remove-carriage-return/m-p/477721#M178445 <HTML><HEAD></HEAD><BODY><P>I have some data in excel</P><P>as</P><P></P><TABLE border="0" cellspacing="0" frame="VOID" rules="NONE"><TBODY><TR><TD height="34" width="170">COMPLETE<BR />ECR-0001479</TD></TR><TR><TD height="34">COMPLETE<BR />ECR-0002435</TD></TR><TR><TD height="34">COMPLETE<BR />ECR-0002780</TD></TR><TR><TD height="34">COMPLETE<BR />ECR-0003223</TD></TR><TR><TD height="34">COMPLETE<BR />ECR-0003670</TD></TR></TBODY></TABLE><P>where there is carriage return(Alt+enter) in the values.</P><P></P><P>Any idea how to remove it via subfield.....</P><P></P><P>Regards</P><P>Nitin</P></BODY></HTML> Thu, 12 Dec 2013 12:34:30 GMT https://community.qlik.com/t5/QlikView/Remove-carriage-return/m-p/477721#M178445 Anonymous 2013-12-12T12:34:30Z Re: Remove carriage return https://community.qlik.com/t5/QlikView/Remove-carriage-return/m-p/477722#M178446 <HTML><HEAD></HEAD><BODY><P>Could you please post a sample excel file?</P></BODY></HTML> Thu, 12 Dec 2013 12:38:19 GMT https://community.qlik.com/t5/QlikView/Remove-carriage-return/m-p/477722#M178446 giakoum 2013-12-12T12:38:19Z Re: Re: Remove carriage return https://community.qlik.com/t5/QlikView/Remove-carriage-return/m-p/477723#M178447 <HTML><HEAD></HEAD><BODY><P>PFA the sample excel file</P></BODY></HTML> Thu, 12 Dec 2013 12:43:04 GMT https://community.qlik.com/t5/QlikView/Remove-carriage-return/m-p/477723#M178447 Anonymous 2013-12-12T12:43:04Z Re: Remove carriage return https://community.qlik.com/t5/QlikView/Remove-carriage-return/m-p/477724#M178448 <HTML><HEAD></HEAD><BODY><P>LOAD Replace(DATA, Chr(10), ' ') as data</P><P>FROM</P><P>C:\Users\user\Downloads\sample1.xls</P><P>(biff, embedded labels, table is [Sheet1$]);</P></BODY></HTML> Thu, 12 Dec 2013 12:48:18 GMT https://community.qlik.com/t5/QlikView/Remove-carriage-return/m-p/477724#M178448 giakoum 2013-12-12T12:48:18Z