Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
ColumnA_without_zero_width_space = PurgeChar(ColumnA, Chr(8203));
Or
ColumnA_without_zero_width_space = Concat(SubField(ColumnA, Chr(8203), RowNo()), '');
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