Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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...

4 Replies
vikasmahajan

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.
tresesco
MVP
MVP

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
bwohletz
Contributor II
Contributor II

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