Remove blank space in a string from a Excel file in the data load editor

[vlntn]

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.

[sunny_talwar · Accepted solution]

May be it is Chr(160), try this

PurgeChar(FieldName, Chr(160)) and see if this works

[vlntn]

That worked. Thank you!