SAP Knowledge Base Article - Public

3248705 - How to remove spaces between words in a column? - Story report [People Analytics]

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 HXM 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 HXM Suite all versions

Attachments

Pasted image.png