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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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