Linebreak as delimiter for SubField()

[Anonymous]

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 · Accepted solution]

You can use CHR(10)

[PrashantSangle]

Hi,

use

SubField(Text, chr(10))

[peterkumar]

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