topic Remove CR LF in LOAD statement in QlikView https://community.qlik.com/t5/QlikView/Remove-CR-LF-in-LOAD-statement/m-p/705181#M1062348 <HTML><HEAD></HEAD><BODY><P>Hi, i have a field in a LOAD statement which sometimes ends with a CR LF character, how can i remove it in the LOAD statement?</P></BODY></HTML> Fri, 26 Sep 2014 11:05:10 GMT 2014-09-26T11:05:10Z Remove CR LF in LOAD statement https://community.qlik.com/t5/QlikView/Remove-CR-LF-in-LOAD-statement/m-p/705181#M1062348 <HTML><HEAD></HEAD><BODY><P>Hi, i have a field in a LOAD statement which sometimes ends with a CR LF character, how can i remove it in the LOAD statement?</P></BODY></HTML> Fri, 26 Sep 2014 11:05:10 GMT https://community.qlik.com/t5/QlikView/Remove-CR-LF-in-LOAD-statement/m-p/705181#M1062348 2014-09-26T11:05:10Z Re: Remove CR LF in LOAD statement https://community.qlik.com/t5/QlikView/Remove-CR-LF-in-LOAD-statement/m-p/705182#M1062349 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; FieldA, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; FieldB, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>replace(replace(FieldC, chr(13), ''),chr(10),'') as FieldC,</STRONG></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; ...etc</EM></P><P>FROM ...</P></BODY></HTML> Fri, 26 Sep 2014 11:40:00 GMT https://community.qlik.com/t5/QlikView/Remove-CR-LF-in-LOAD-statement/m-p/705182#M1062349 Gysbert_Wassenaar 2014-09-26T11:40:00Z Re: Remove CR LF in LOAD statement https://community.qlik.com/t5/QlikView/Remove-CR-LF-in-LOAD-statement/m-p/705183#M1062350 <HTML><HEAD></HEAD><BODY><P>Purgechar(Field, chr(10)&amp;chr(13)) as Field</P></BODY></HTML> Fri, 26 Sep 2014 12:08:06 GMT https://community.qlik.com/t5/QlikView/Remove-CR-LF-in-LOAD-statement/m-p/705183#M1062350 MarcoWedel 2014-09-26T12:08:06Z Re: Remove CR LF in LOAD statement https://community.qlik.com/t5/QlikView/Remove-CR-LF-in-LOAD-statement/m-p/705184#M1062351 <HTML><HEAD></HEAD><BODY><P>both are correct, btw i had to use chr 194 and 160, i dunno what combination is</P></BODY></HTML> Fri, 26 Sep 2014 13:07:00 GMT https://community.qlik.com/t5/QlikView/Remove-CR-LF-in-LOAD-statement/m-p/705184#M1062351 2014-09-26T13:07:00Z