SAP Knowledge Base Article - Public

2870410 - How to Remove Leading Zeros in Integration Center - SuccessFactors HXM Suite

Symptom

You would like to remove the leading zeros in your outbound integration center interface. In your scenario, you have some field with variable leading zeros, example sometimes 3 leading zeros, sometime 4 leading zeros.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SuccessFactors HXM Suite
    • Integration center

Resolution

This can be achieved with the simple calculation in the column header.

Please click on the column header

Select Edit Calculation

Choose Remove All option

Provide value ^0+

(note: this string is part of a 'regular expression':

^ = start at the beginning of the line

0 = character to look for

+ = match one or more of the preceding character(s) )

2019-12-05_08-23-04.png

See Also

2597306 How to Add Leading Zeros to a String Field

Opening CSV UTF-8 files correctly in Excel - Microsoft Support

Keywords

remove leading zeros integration center, successfactors hcm hxm suite, 000, 0000, 00, 0, calculated column header, outbound interface , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-INC , Integration Center , How To

Product

SAP SuccessFactors HCM Suite all versions