Add space before field values

[SaiPranathiG]

Hi All,

I had a requirement to add spaces for few field values.

For example, to add space before B, C, E in Category field

Category	Year	Sales($M)
A	2020	50
B	2021	28
C	2018	89
D	2017	78
E	2015	90
F	2019	80

expected output should be like below:

Category	Year	Sales($M)
A	2020	50
B	2021	28
C	2018	89
D	2017	78
E	2015	90
F	2019	80

May i know how to achieve this in QS.

TIA

[Kushal_Chawda]

@SaiPranathiG  you can use below as calculated dimension or in load script to create another field

=if(match(Category,'B','C','E'),Repeat(' ',5)&Category,Category)

[SaiPranathiG]

I have tried the same before, but space is not adding before text. getting trimmed

[SaiPranathiG · Accepted solution]

Space - Chr(160)