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

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

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

    ‏2013-05-30T19:40:43Z  

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

    Good luck,
    Opher

     

  • Paul Mendelson
    Paul Mendelson
    34 Posts

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

    ‏2013-05-30T20:15:47Z  
    • OpherB
    • ‏2013-05-30T19:40:43Z

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

    Good luck,
    Opher

     

    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