Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
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!