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) )
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