SAP Knowledge Base Article - Public

3465880 - The data is getting shifted towards the right column in the output file of type Simple Delimited

Symptom

A comma within a name shifted the part of Preferred name to the Last Name column in the output file. For example, if the name of a user is A B, D E where the Preferred Name is A B, D and the Last Name is E. However, the output of the integration job has Preferred Name as A B and Last Name as D. Due to this all his data shifted to next column (towards right) in the output file. 

Environment

SAP SuccessFactors HXM Suite
* Integration Center

Cause

The Output file type is Simple Delimited which uses delimited formatting that uses different characters to separate data values such as commas, tabs, and colons. As the Preferred name (A B, D) of the employee contains comma (,) the A B and D got delimited to two different columns.

Resolution

The Output file type Simple Delimited uses delimited formatting that uses different characters to separate data values such as commas, tabs, and colons. As the Preferred name (A B, D) of the employee contains comma (,) the A B and D got delimited to two different columns. To resolve the problem, use True CSV Output file type that accommodate special characters such as carriage returns, new lines, double quotes, commas.

Keywords

Simple Delimited, True CSV, Integration Center, delimit, special characters, carriage returns, new lines, double quotes, commas, tabs, colons , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-INC-FWK , Integration Center UI Framework , Problem

Product

SAP SuccessFactors HCM Core 2405