Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

anders_billfors
New Contributor

Linebreak as delimiter for SubField()

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()?

1 Solution

Accepted Solutions
rustyfishbones
Honored Contributor II

Re: Linebreak as delimiter for SubField()

You can use CHR(10)

2 Replies
rustyfishbones
Honored Contributor II

Re: Linebreak as delimiter for SubField()

You can use CHR(10)

Re: Linebreak as delimiter for SubField()

Hi,

use

SubField(Text, chr(10))

Regards,
Prashant Sangle
Community Browser