SAP Knowledge Base Article - Public

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


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


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


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


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 (|).


5. Click 'Apply' > 'Okay'.


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 , Learning Management System , How To


SAP SuccessFactors Learning all versions