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: 
Newuser_qlik
Contributor II
Contributor II

How to remove zero width space in Qliksense

Hi,

I'm using chr(8203) to get the leading zeros when storing in CSV format. But what happens is the number fields are present as text fields and there is also a zero width space. 

e.g: Column A has a value 0.0

And column A is derived in the script as: Chr(8203)&Column A as Column A. [THIS IS TO KEEP THE LEADING ZEROS IN CSV]

but when checked the len() it shows as 4.

i want to remove the zero width space in Qlik sense. any help.

TIA

Labels (4)
2 Replies
Chanty4u
MVP
MVP

Try this 

ColumnA_without_zero_width_space = PurgeChar(ColumnA, Chr(8203));

 

Or 

ColumnA_without_zero_width_space = Concat(SubField(ColumnA, Chr(8203), RowNo()), '');

 

Newuser_qlik
Contributor II
Contributor II
Author

@Chanty4u 

But I need chr(8203) in my script. if i use purgechar, i get values as 1, 2, and not as 1.0 or 2.0