Re: remove newline character - Qlik Community

Report Inappropriate Content · ‎2013-09-02

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

vikasmahajan · ‎2013-09-02

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 · ‎2013-09-02

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

Gysbert_Wassenaar · ‎2013-09-04

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

talk is cheap, supply exceeds demand

bwohletz · ‎2017-06-28

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