Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Removing newlines?

Hi I need to remove all newlines in an object.

I tried using: replace(field , chr(10) , ' ') :but they were not replaced.

Is it even possible?

1 Solution

Accepted Solutions
Not applicable
Author

Hi the thing was that there were both a chr(10) and chr(13) for the newline so replacing/removing both got it working

View solution in original post

4 Replies
Not applicable
Author

Hi ,

Check it out using the PurgeChar function ...

Regards,

Chakravarthy.

Not applicable
Author

Nah dosn't work =(

Not applicable
Author

Hi ,

Can you please post an example .. I will work it out .

Regards,

Chakravarthy.

Not applicable
Author

Hi the thing was that there were both a chr(10) and chr(13) for the newline so replacing/removing both got it working