Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

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 (4)
1 Solution

Accepted Solutions

May be it is Chr(160), try this

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

View solution in original post

2 Replies

May be it is Chr(160), try this

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

View solution in original post

Contributor II
Contributor II

That worked. Thank you!