Symptom
Double quotes ("") in a .csv report.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Log in to Learning Administration >
- Go to 'Reports' tab >
- Select any .csv report >
- Change the 'CSV Report Delimiter' to any value but comma (,). Ex: Pipe. >
- Populate desired filter criteria and click on 'Run Report' >
- 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.
- Go to the Control Panel >
- Select 'View by' = 'Small icons' >
- Select 'Region' >
- Go to 'Additional settings' >
- Change the 'List separator' to pipe (|) >
- 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