Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
That unfortunately is still adding a line break.
Can you post a small qlikview document that demonstrates the problem?