SAP Knowledge Base Article - Public

2606715 - LMS: Double Quotes ("") in an LMS CSV Report

Symptom

  •  Double Quotes ("") in an LMS CSV Report

Environment

SAP Successfactors Learning Management System (LMS)

Reproducing the Issue

  1. Log in to LMS.
  2. Go to 'Admin' tab.
  3. Click 'Reports'.
  4. Select any CSV report.
  5. Change the 'CSV Report Delimiter' to any value but comma (,). (Ex: Pipe)
  6. Populate desired filter criteria and click 'Run Report'.
  7. Notice that the output contains unnecessary double quotes. Ex: User ID|"First Name"|"Last Name

Cause

The CSV Report Delimiter you set is different from your local machine's list separator.

Resolution

The CSV Report Delimiter and list separator should be the same.

For Windows Only

If you want to use pipe (|) as the CSV Report Delimiter, for example, you need to change your local machine's list separator.

  1. Go to Control Panel.
  2. Select View by = 'Small icons'.
  3. Select 'Region' > 'Additional settings'.
  4. Change the 'List separator' to pipe (|).

Untitled.png

5. Click 'Apply' > 'Okay'.

Keywords

quote, double quote, ","", CSV, PRD, report, LMS, Learning, Pipe, Comma, Delimiter, separator, CSV Report Delimiter, control panel, windows , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , SuccessFactors Learning , How To

Product

SAP SuccessFactors Learning all versions