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

Moritz Funk
Moritz Funk Active Partner
First Anniversary First Comment 5 Up Votes 5 Likes

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

Answers

  • Hi Moritz,

     

    it does work in Nexel.

     

    BR
    Helmut

  • Moritz Funk
    Moritz Funk Active Partner
    First Anniversary First Comment 5 Up Votes 5 Likes

    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

  • 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
    Etienne CAUSSE Customer
    First Anniversary Advocate Community Voices Name Dropper
    edited March 2020

    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.

     

    image

    image

    image

     

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