Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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),''))
Thanks for this, works for me. i am here to find such solution. Thanks again!
Thanks to close.
K, Srinivasan