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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-09-02 06:15 AM

remove newline character

How to delete a new line character from a column in Qlikview

Some Users have entered Enter in Description column. How do i remove them now. I tried replace(Description',char(10),'')

but didnt work...

Labels (1)
Labels
7,834 Views
0 Likes
4 Replies
vikasmahajan
MVP
MVP
‎2013-09-02 06:54 AM

Can u explain in details what you want to achieve ?

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
6,442 Views
0 Likes
tresB
Champion III
Champion III
‎2013-09-02 07:00 AM

replace(YourField,chr(10),'')              // Chr() not Char() , did you write that correctly?

6,442 Views
0 Likes
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III
‎2013-09-04 01:46 PM

You may need to strip chr(13) too: replace(replace(Description,chr(10),''),chr(13),'')


talk is cheap, supply exceeds demand
6,442 Views
bwohletz
Contributor II
Contributor II
‎2017-06-28 02:57 AM

use  purgechar(FieldName,CHR(10)) AS FieldName,

6,442 Views
0 Likes