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
it does work in Nexel.
Found a way to do it with a funny Workaround:
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 :-)
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 ;-)
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...
Retrieving data ...