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

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

SAP SuccessFactors Learning

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".

1. The CSV Report Delimiter you set is different from your local machine's list separator.
2. The application used to open the file does not interpret CSV files correctly.

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

1. 1. Click 'Apply' > 'Okay'.
2. Ensure that the report file is being opened with an application that supports and correctly interprets CSV files like Microsoft Excel. CSV files generated from Learning reports adhere to a standard format defined by RFC 4180, which includes the use of double quotes to encapsulate certain data. Applications like Notepad and Notepad++ can open CSV files, but cannot interpret them correctly to suppress the double quotes.

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