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 SuccessFactors Learning.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Login to SAP SuccessFactors Learning >
  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 Learning 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

lms, learning, successfactors, report, export, save, csv, line break, line, feed, wrap, break, linebreak, crlf, cr, lf, \n, \r, \n,\r, symbol, character, code, encode, coding , KBA , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors Learning all versions