Symptom
How to remove space between 2 words in a column?
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 HCM Suite
- People Analytics
Resolution
We can do that by using a calculated column with the following formula:
REPLACE(COLUMN_NAME," ","")
Note: This is not possible in Table or Canvas reports.
Keywords
People Analytics, Story Report, Space, Spaces, Blank, Words, Word, Columns, Fields, Calculated Column, Formula, Replace, Table, Canvas, Detailed, Advanced, Adhoc, Ad Hoc , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To
Product
SAP SuccessFactors HCM Suite all versions
Attachments
image.png |
image.png |
Pasted image.png |