Removal of Space while excel export

[ak77]

Hi All,

i have a report where i need to use space to display data in dashboard based on requirement as below. I have used UNICHAR(12288) to display space character in dashboard and is working fine.. But when i export it to Excel (csv), is there a way to remove these space characters as my user needs these spaces to be  removed during export . 

[ak77]

@danextian Thanks for reply. i want to  solve removal of spaces when u export the data to Excel/CSV. The dashboard will display the spaces . i have requirement only to trim the spaces during export to excel 

[danextian]

Hi @ak77 

Have you tried trim or clean in the query editor. Seems like UNICHAR(12288)  is treated just like any other space characters. The contextual menu  should appear when you right click a column header.

[danextian]

Hi @ak77 ,

What you display in the visual is what you will be exporting.