Symptom
You wish to find out why, when carrying out an import via Integration Center the inclusion of “/” or “\” results in errors. Removing these characters allows the import to succeed.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Integration Center
Resolution
This is a data-driven issue which occurs only when the CSV data has a single backslash at the end of a field. For example:
It is a standard practice in Java to consider single backslash \ as an escape character, and all third-party libraries adhere to this standard. According to the documentation of the third-party library, if you want to treat \ as a literal character, you must provide a double backslash instead of a single backslash:
https://ostermiller.org/utils/doc/com/Ostermiller/util/CSVParser.html
To address this issue, you must provide the CSV data in the correct format, using double backslashes for backslash literals.
NOTE: All other special characters are allowed, including forward slash /. The issue occurs only with single backslash \ at end of the field.
See Also
Keywords
backslash, back slask, slash, integration center, integration centre, IC, import, CSV, “/” , “\” , KBA , LOD-SF-INT-INC-JOB , Integration Center Job , LOD-SF-INT-INC , Integration Center , Problem