Topic
2 replies Latest Post - ‏2013-05-30T20:15:47Z by Paul Mendelson
KaurGurleen
KaurGurleen
1 Post
ACCEPTED ANSWER

Pinned topic Remove/replace CRLF or show one row per record without merging rows

‏2013-05-30T16:42:34Z |

When I export my report to excel , It takes multiple lines and merge them as the data has CRLF in it. So report cannot be sorted in excel. 

Is there any way I can remove CRLF or can set one row per record for excel.

Updated on 2013-05-30T16:42:59Z at 2013-05-30T16:42:59Z by KaurGurleen
  • OpherB
    OpherB
    664 Posts
    ACCEPTED ANSWER

    Re: Remove/replace CRLF or show one row per record without merging rows

    ‏2013-05-30T19:40:43Z  in response to KaurGurleen

    I suggest you try exporting as CSV and then opening that file in Excel.

    Good luck,
    Opher

     

    • Paul Mendelson
      Paul Mendelson
      34 Posts
      ACCEPTED ANSWER

      Re: Remove/replace CRLF or show one row per record without merging rows

      ‏2013-05-30T20:15:47Z  in response to OpherB

      Try using the following:

       

      replace(replace([namespace].[table].[field],CHAR(10),' '),CHAR(13),' ')

       

      That will replace the newline/carriage return chars with spaces.

      Updated on 2013-05-30T20:16:52Z at 2013-05-30T20:16:52Z by Paul Mendelson