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. Manager’s 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
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