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: 
vlntn
Contributor III
Contributor III

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

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.

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

May be it is Chr(160), try this

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

View solution in original post

2 Replies
sunny_talwar

May be it is Chr(160), try this

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

vlntn
Contributor III
Contributor III
Author

That worked. Thank you!