How to remove spaces in qlikview script.

[viveksingh]

Hi Experts,

I have a qlikview script  where I'm reading from QVS file. I'm getting spaces in script log.  I want to remove the spaces which is appearing in script.  Below is the screen shot.

Please help on the above

[asinha1991]

not sure if this is your issue, but there is something called non breaking space which doesn't get replaced by trim..it has ascii 160 , you can copy paste your text in some ascii online converter and see if you get this or simply try

trim(replace(yourfied,chr(160),''))

[Luke69857]

Thanks for this, works for me. i am here to find such solution. Thanks again!

[Ksrinivasan]

Thanks to close.

K, Srinivasan