SAP Knowledge Base Article - Public

2934326 - Problem with sentence Replace All and Remove All in Calculated field - Integration Center

Symptom

You are observing one problem in the Integration center using the option Replace All in the field calculation to replace the character "." 

The system indentify all the characters of the string as "." as Replace all of them instead only the "."

It happens also with the sentence Remove All.

Environment

  • SAP SuccessFactors HCM HXM Suite
    • Integration center

Resolution

Please use the character '\' before '.' i.e. put '\.' when you want to do remove all or replace all.

As '.' is a special character hence, you must add a backslash before it to get it working.

This is also mentioned in Integration center guide:

When using a Replace All or Remove All operation to replace or remove a special character, you must use \ (backslash) as an escape character before the special character. For example, in the string Integration, you want to replace ? with a. In the Text to Remove field, you must therefore enter \?

Keywords

Integration center, dot, replace all, remove all, backslash, not working, calculated field, SAP SuccessFactors HXM HCM Suite, string field,  , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HXM Suite all versions