Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
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

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

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


talk is cheap, supply exceeds demand