SAP Knowledge Base Article - Public

2377452 - Ad hoc report scheduled export delimiter

Symptom

Can the delimiter used in a CSV export of an ad hoc report be changed to something else, e.g. tab or ^?

Environment

BizX ad hoc reporting

Resolution

No.  CSV has "comma-separated values" by definition and another character cannot be substituted.  The other options for export are Excel, PPT and PDF but these cannot be viewed correctly as plain text files, let alone reconfigured with respect to the delimiter.

The only option is to run a search and replace on the export after receiving it.  There are many ways to use macros or executables to achieve this if you do not wish to do it manually.  Note that if you change the delimiter you may need to change the file extension because it will no longer be readable as a CSV file.

Keywords

KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To

Product

SAP SuccessFactors HCM Core 1608