Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Line Break after coping data from list box.

Hi All,

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.

The data from the source DB has been verified, no spaces/line breaks.

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps the value ends with a LineFeed and/or CarriageReturn character. Try removing those in the script:

purgechar(MyField, chr(10)&chr(13) as MyField


talk is cheap, supply exceeds demand
Not applicable
Author

That unfortunately is still adding a line break.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Can you post a small qlikview document that demonstrates the problem?


talk is cheap, supply exceeds demand