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: â€™
- SAP SuccessFactors HXM Suite
- Integration Center
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. Manager’s instead of Manager's)
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: '
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