SAP Knowledge Base Article - Public

2360694 - What Line Break symbol is used in reports exported to csv in LMS?

Symptom

You would like to know what symbol is used for the line break / feed for reports exported to .csv from the Learning Management System

Environment

  • SAP SuccessFactors
  • Learning Management System (LMS)

Reproducing the Issue

  1. Login to LMS
  2. Navigate to Reports
  3. Choose a report to export to .csv
  4. Open the report in MS Excel and note each row of data is separated in a new line
  5. Open the same .csv file in Notepad and the data is all on one line, with no line break

 

Cause

The LMS servers are Unix servers, so the line breaks are LF (\n)

Resolution

If a Windows line break is needed, the file can be opened in WordPad or MS Word and then saved which will add in the CRLF (\r\n) symbols for line breaks

Keywords

SF SuccessFactors Success Factors Learning Management System LMS export save exported saving exporting csv comma delimited text txt line feed wrap break linebreak crlf cr lf \n \r \n\r symbol character code encode coding  , KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning 1602 ; SAP SuccessFactors Learning 1605 ; SAP SuccessFactors Learning 1608