Trim Excel Column Data - Qlik Community

Report Inappropriate Content · ‎2013-08-27

Dear Folks,

I have a scenario , where i need to perform cleansing on an excel column.

I believe Location columns contain spaces in it , but when i perform trim, purgechar operations. It fails to remove the spaces.

Have attached the sample files.

Regards,

Vasim

MayilVahanan · ‎2013-08-27

HI

Try like this

KeepChar(Trim(Location),'ABCDEFGHIJKLMNOPQRSTUVWXYZ') as Location,

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2013-08-27

Use PurgeChar(Location, chr(32) & chr(160))

In location files, sometimes it is used the ascii 160 as space.

tresesco · ‎2013-08-27

As said by Juan, this is because of non-breaking space character represented by ascii 160. So the following should work for you:

Purgechar(Location, chr(160)) as NewLocation.

Report Inappropriate Content · ‎2013-08-31

Thanks a lot mayil, juan and tresesco.

I managed to get rid of non breaking space by using Purgechar(Location, chr(160)).