Is there an equivalent to char(13) & char(10) in BOARD layout?

Moritz Funk

Hi,

I would like to use this to create a multi-line text in a layout / dataflow.

I know it works in Data Reader ETL.

Thanks and BR

Moritz

Find more posts tagged with

Accepted answers

All comments

Helmut Heimann

Hi Moritz,

it does work in Nexel.

BR
Helmut

Moritz Funk

Found a way to do it with a funny Workaround:

Create an 1-item-Enttiy and create a text-cube with only this Dimension.
Fill this cube in a dataview with:
"1
2"
So you have CR;LF on Position 2 and 3
Use this cube (defined as b) in your dataflow with

right(left(b,3),2)
And you can get your CR;LF on the desired Position.

I'm not quite happy with this solution, so if you know a better one, please post it.

I'm also interested in a how-to-in-nexcel from Helmut Heimann :-)

BR
Moritz

Helmut Heimann

Hi Moritz,

put short: introduce a character in your textstring that shall be replaced by CR/LF (i.e. '#'), afterwards, just use the "substitute" function Nexel offers to replace this character.

And, yes you might want to use the Nexel writeback to store those values into a cube ;-)

Helmut

Etienne CAUSSE

Nice trick Moritz Funk

You can make it even simpler by using a text cube where you have only the CR;LF, and structure it by year (simplest entity already available and already present in the log cube).

This avoids creating an entity. I just tested it and it works well to feed my new log cube.

Of course it would be nice to avoid creating a cube for 1 character...