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

pls try this

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?