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