How to get item descriptions with line breaks into a neat report?

[UweStieglitz]

When you pull an LMS standard report or PRD custom report which includes item descriptions and audience descriptions, then the result in csv is distorted, if the descriptions contain line breaks or line feeds. 

Do you have any suggestions how to fix this? 

Thanks, Uwe

[nishadsthakur]

line breaks caused by special characters, usually item descriptions are copied from microsoft word it will create those type line breaks, I also ran into this situation and tried everything to eliminate it from sql-code but it wont work
only way is to rework on description inside LMS.
another workaround involves background elements.
for my scenario, i want to send custom report to linkedin sftp, to achieve that i created custom prd which sends item data(id,type,dte,desc) along with format of live data import templates(^userid,^assigmentid,lms_background_element)

then i created integration centre report which removes multiple special characters and again sends the data to new background element

now I schedule report for linkedin using newly created background element using integration centre
if you want to only create report for user/admin consumption then you can report using stories or ord

[UweStieglitz]

Hi Nishadsthakur, Thanks for this long explanation. Today I tried again to find a solution for this problem. I asked ChatGPT for ideas. And it suggested several ways to work with JavaScript in BIRT. I tried them all and they all failed. :-(. Now I will take up your hint and talk to some of my colleagues, if the integreation center might be able to help here. Or - next idea triggered by your reply - I will ask the middleware colleagues (we use CPI), if CPI can pick up my report and remove any special characters...