Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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!