Topic
4 replies Latest Post - ‏2013-03-14T10:30:25Z by SystemAdmin
vipirailo
vipirailo
63 Posts
ACCEPTED ANSWER

Pinned topic Line feed in TM1 cell

‏2012-09-12T12:59:06Z |
Hi, can TM1 cubes store string value with line feed?
For example i need text1 be formatted and stored in TM1 cell like text2
text1:

Admin 2012/09/12 17:00:13 comment1;Admin 2012/09/12 17:00:15 comment2;Admin 2012/09/12 17:01:33 comment3;


text2:

Admin 2012/09/12 17:00:13 comment1 Admin 2012/09/12 17:00:15 comment2 Admin 2012/09/12 17:01:33 comment3;
Updated on 2013-03-14T10:30:25Z at 2013-03-14T10:30:25Z by SystemAdmin
  • vipirailo
    vipirailo
    63 Posts
    ACCEPTED ANSWER

    Re: Line feed in TM1 cell

    ‏2012-09-12T13:46:09Z  in response to vipirailo
    Was solved by the usage of CHAR(10)|'@' in TI process.
    @ sings were erased by excell function
    • Rizwan.Kaif
      Rizwan.Kaif
      197 Posts
      ACCEPTED ANSWER

      Re: Line feed in TM1 cell

      ‏2012-09-12T14:49:46Z  in response to vipirailo
      Great that you have resolved it yourself

      I think you just need to have the CHAR() function and you dont need to have @ symbol there.
      Cheers!
      Rizwan Kaif
      • vipirailo
        vipirailo
        63 Posts
        ACCEPTED ANSWER

        Re: Line feed in TM1 cell

        ‏2012-09-12T15:15:03Z  in response to Rizwan.Kaif
        Hi, Rizwan. Unfortunately it doesn't work for me. And i have to add some printable symbol after CHAR(10) be replaced by excel function
  • SystemAdmin
    SystemAdmin
    658 Posts
    ACCEPTED ANSWER

    Re: Line feed in TM1 cell

    ‏2013-03-14T10:30:25Z  in response to vipirailo
    http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/a87b9fbb-40dc-4a2e-83df-eab150620122

    ***If you want to generate a line break, it is a good practice to use CR and LF together. CHAR(13) + CHAR(10)***