Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Possible to remove new lines from a field?

I have a field called Comments and the values in the field (strings) sometimes include new lines.  The issue is when I represent this field on a straight table, even with the cell wrap upped to 4 lines, some of the string is getting cut off.  I am wondering if it's possible to remove new lines all together from the values in the field? 

1 Solution

Accepted Solutions
jerem1234
Valued Contributor II

Re: Possible to remove new lines from a field?

Try:

replace(FIELD, chr(10), ' ')

This will replace the new lines with a space.

Hope this helps!

3 Replies
jerem1234
Valued Contributor II

Re: Possible to remove new lines from a field?

Try:

replace(FIELD, chr(10), ' ')

This will replace the new lines with a space.

Hope this helps!

jerem1234
Valued Contributor II

Re: Possible to remove new lines from a field?

If you want to completely remove it, use:

purgechar(FIELD, chr(10))

Not applicable

Re: Possible to remove new lines from a field?

Hi,

check the applicaton. Test data is as below.

IDComments
11 First String
1 Second String
1 Third String
22 First String
2 Second String
33 Frist String
44 Frist String
55 Frist String
5 Second String
5 Third String
5 Fourth String
5 Fifth String
Community Browser