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
- Login to LMS
- Navigate to Reports
- Choose a report to export to .csv
- Open the report in MS Excel and note each row of data is separated in a new line
- 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 , Learning Management System , Problem