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

Helmut Heimann

Hi Moritz,

 

it does work in Nexel.

 

BR
Helmut

Moritz Funk

Found a way to do it with a funny Workaround:

 

1. Create an 1-item-Enttiy and create a text-cube with only this Dimension.
2. Fill this cube in a dataview with:
   "1
   2"
   So you have CR;LF on Position 2 and 3
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 ;-)

 

BR

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...