Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to remove a blank space of a string which was loaded from an Excel file into Qlik Sense via the Data Load Editor.
The string in the Excel column basically looks like this: "123a " (with a blank space at the end)
I already tried several functions e.g. trim, rtrim, replace, and PurgeChar. Unfortunately, nothing works.
Does anyone have an idea how to solve this?
Thanks in advance.
May be it is Chr(160), try this
PurgeChar(FieldName, Chr(160)) and see if this works
May be it is Chr(160), try this
PurgeChar(FieldName, Chr(160)) and see if this works
That worked. Thank you!