Forum Discussion

jay_za's avatar
jay_za
Frequent Visitor
2 years ago

Retaining line breaks in exported report data

Hi everyone   Apologies if this is the wrong forum. It seemedl ike the best bet.   I've built a fairly straightforward report using Salesforce reports as datasources. One of the fields is a fairl...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

or

jay_za's avatar
jay_za
Frequent Visitor
2 years ago

Hi Ahmed

 

I appreciate the thoughts, but a) unicode 160 is a non-breaking space, not any form of line break, and b) I can get it to display perfectly in a Power BI table using UNICHAR(10) or (13). As detailed in my first post, I need to find a way for the line breaks to carry through into a csv or xlsx when I export the table data.

 

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    it this way when exporting line breaks will save

    • jay_za's avatar
      jay_za
      Frequent Visitor
      2 years ago

      Thank you! I apologise for just assuming and not testing first.

       

      Including UNICHAR(160) adds an odd character to the field in the csv, so I took it out. Just leaving the UNICHAR(10) keeps the line break now though. What is different in how you did it? Is it the {} surrounding the formula?

    • jay_za's avatar
      jay_za
      Frequent Visitor
      2 years ago

      Just a follow up note: I can export from the visual in desktop and it retains the line breaks perfectly. Once I publish, though, I need to specify exporting summarised data to csv - none of the other formats retain them.