topic Line Break after coping data from list box. in QlikView https://community.qlik.com/t5/QlikView/Line-Break-after-coping-data-from-list-box/m-p/1161129#M378537 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In my qlikview sheet, I have list boxes that contain data. When copying a selected record and pasting it into another program like notepad or excel, it never fails to add an extra line after the last record. Is there a way to remove that? I checked the List Box properties, but I don't see anything that may help with this.</P><P></P><P>The data from the source DB has been verified, no spaces/line breaks.</P></BODY></HTML> Thu, 09 Jun 2016 12:45:06 GMT 2016-06-09T12:45:06Z Line Break after coping data from list box. https://community.qlik.com/t5/QlikView/Line-Break-after-coping-data-from-list-box/m-p/1161129#M378537 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>In my qlikview sheet, I have list boxes that contain data. When copying a selected record and pasting it into another program like notepad or excel, it never fails to add an extra line after the last record. Is there a way to remove that? I checked the List Box properties, but I don't see anything that may help with this.</P><P></P><P>The data from the source DB has been verified, no spaces/line breaks.</P></BODY></HTML> Thu, 09 Jun 2016 12:45:06 GMT https://community.qlik.com/t5/QlikView/Line-Break-after-coping-data-from-list-box/m-p/1161129#M378537 2016-06-09T12:45:06Z Re: Line Break after coping data from list box. https://community.qlik.com/t5/QlikView/Line-Break-after-coping-data-from-list-box/m-p/1161130#M378538 <HTML><HEAD></HEAD><BODY><P>Perhaps the value ends with a LineFeed and/or CarriageReturn character. Try removing those in the script:</P><P></P><P>purgechar(MyField, chr(10)&amp;chr(13) as MyField</P></BODY></HTML> Thu, 09 Jun 2016 15:49:23 GMT https://community.qlik.com/t5/QlikView/Line-Break-after-coping-data-from-list-box/m-p/1161130#M378538 Gysbert_Wassenaar 2016-06-09T15:49:23Z Re: Line Break after coping data from list box. https://community.qlik.com/t5/QlikView/Line-Break-after-coping-data-from-list-box/m-p/1161131#M378539 <HTML><HEAD></HEAD><BODY><P>That unfortunately is still adding a line break.</P></BODY></HTML> Sat, 11 Jun 2016 20:34:02 GMT https://community.qlik.com/t5/QlikView/Line-Break-after-coping-data-from-list-box/m-p/1161131#M378539 2016-06-11T20:34:02Z Re: Line Break after coping data from list box. https://community.qlik.com/t5/QlikView/Line-Break-after-coping-data-from-list-box/m-p/1161132#M378540 <HTML><HEAD></HEAD><BODY><P>Can you post a small qlikview document that demonstrates the problem?</P></BODY></HTML> Sun, 12 Jun 2016 16:16:54 GMT https://community.qlik.com/t5/QlikView/Line-Break-after-coping-data-from-list-box/m-p/1161132#M378540 Gysbert_Wassenaar 2016-06-12T16:16:54Z