topic Linebreak as delimiter for SubField() in QlikView

Linebreak as delimiter for SubField()

Anonymous — Tue, 11 Mar 2014 15:44:22 GMT

I've been using SubField(Text, ' ') to split a text up into words.

In addition to that I obviously also want to split it when there is a linebreak but I can't seem to figure out how to use that as a delimiter.

I've tried using \n and/or \r as a delimiter string but that didnt work.

Anyone got a clue about how to parse a linebreak with SubField()?

rustyfishbones — Tue, 11 Mar 2014 15:48:56 GMT

You can use CHR(10)

PrashantSangle — Tue, 11 Mar 2014 15:54:51 GMT

Hi,

use

SubField(Text, chr(10))

peterkumar — Mon, 10 Feb 2020 14:49:40 GMT

Thanks!

How do i create a line break in a cell in a pivot table?

Chr(10) does not seem to work.

It works in a table.

Thanks again!

Peter