SAP Knowledge Base Article - Public

3109151 - Integration Center: Apostrophe displayed as ’ in .CSV output file

Symptom

You have configured an simple outbound Integration Center job which is exporting a .csv file to an SFTP server.

When opening the file in Microsoft Excel, you observe that the apostrophe characters are being displayed as: ’

Environment

  • SAP SuccessFactors HXM Suite
  • Integration Center

Cause

This behavior is occurring due to the character which is stored in the field which has the issue.

The apostrophe character is stored as instead of ' (e.g. Managers instead of Manager's)

Resolution

The character stored in the problematic field needs to be changed FROM: TO: ' so that it is rendered correctly in MS Excel:

  • Microsoft Excel will display character as: ’
        
  • Microsoft Excel will display character ' as: '

See Also

Integration Center Guide

Keywords

apostrophe, csv, excel, special character, ’, integration center, sftp,  , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , LOD-SF-INT , Integrations , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HXM Suite all versions