Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
viveksingh
Creator III
Creator III

How to remove spaces in qlikview script.

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.

clipboard_image_0.png

 

Please help on the above

Labels (3)
12 Replies
asinha1991
Creator III
Creator III

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
Contributor
Contributor

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

Ksrinivasan
Specialist
Specialist

Thanks to close.

K, Srinivasan