SAP Knowledge Base Article - Public

2324690 - How to create/update records via a connector where the delimiter is included within a field

Symptom

This KBA will display how to create or update records via any connector where the delimiter is included within a field.

On the example below, the field delimiter is a pipe character(|) and the same character is included in the title of an item:

CPNT_ID|CPNT_TYP_ID|NOTACTIVE|CPNT_TITLE!##!
TESTITEM|ILT|N|Title | with pipe(|) delimiter included within field !##!

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Populate input file with delimiter contained within a field >
  2. Run Connector >
  3. Connector Job fails or does not update as expected as pipe contained within the title field is treated as a delimiter.

Resolution

To make sure the conenctor does not treat the character as a delimiter it is importantto set up both the delimiter property and the escape character property in the connector configuration, and then configure our input file accordingly.

For example, if a pipe (|) character was utilized as the delimiter and a quotation mark as the escape character, we would set the two properties up as follows:

On System Admin > Configuration > System Configuration > Connectors:

connector.input.file.escapeChar="
connector.input.file.columnDelimiter=|

In this instance, the input file would have to look like the following (where pipe (|) delimits or defines where one field ends/starts and a quotation mark (") encloses the field where the same delimiter character is contained within a particular field):

CPNT_ID|CPNT_TYP_ID|NOTACTIVE|CPNT_TITLE!##!
TESTITEM|ILT|N|"Title | with pipe(|) delimiter included within field"!##!

Keywords

Connectors, delimiters, escape, characters, LMS, pipe, quotation, comma, configuration, learning, administration , KBA , LOD-SF-LMS-CON , Connectors , How To

Product

SAP SuccessFactors Learning all versions