SAP Knowledge Base Article - Public

2606715 - Double quotes ("") in a .csv report

Symptom

Double quotes ("") in a .csv report.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Log in to Learning Administration >
  2. Go to 'Reports' tab >
  3. Select any .csv report >
  4. Change the 'CSV Report Delimiter' to any value but comma (,). Ex: Pipe. >
  5. Populate desired filter criteria and click on 'Run Report' >
  6. 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 the Control Panel >
  2. Select 'View by' = 'Small icons' >
  3. Select 'Region' >
  4. Go to 'Additional settings' >
  5. Change the 'List separator' to pipe (|) >

Untitled.png

  1. Click 'Apply' > 'Okay'.

Keywords

lms, learning, sf, successfactors, quote, double,","", csv, prd, report, pipe, comma, delimiter, separator, control, panel, windows , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , How To

Product

SAP SuccessFactors Learning all versions