topic Re: Possible to remove new lines from a field? in QlikView

Possible to remove new lines from a field?

Fri, 20 Jun 2014 20:07:58 GMT

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?

Re: Possible to remove new lines from a field?

jerem1234 — Fri, 20 Jun 2014 20:17:13 GMT

Try:

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

This will replace the new lines with a space.

Hope this helps!

Re: Possible to remove new lines from a field?

jerem1234 — Fri, 20 Jun 2014 20:22:13 GMT

If you want to completely remove it, use:

purgechar(FIELD, chr(10))

Re: Possible to remove new lines from a field?

Sat, 21 Jun 2014 19:58:45 GMT

Hi,

check the applicaton. Test data is as below.

ID	Comments
1	1 First String 1 Second String 1 Third String
2	2 First String 2 Second String
3	3 Frist String
4	4 Frist String
5	5 Frist String 5 Second String 5 Third String 5 Fourth String 5 Fifth String

Re: Possible to remove new lines from a field?

yakir_manor — Thu, 18 Jul 2019 08:29:57 GMT

see the following links:

1. Newline - Wikipedia

2. Whitespace - Wikipedia

for me i needed to remove newline and whitespace so i use:

let vNewString = replace(replace(replace(vString, chr(13), ''), chr(10), ''), ' ', '');

enjoy!