topic Remove an unwanted special character in QlikView

Remove an unwanted special character

Anonymous — Wed, 30 May 2012 16:34:01 GMT

Does anybody have any ideas on how to get rid of this character from a text string?

I tried replace, but it doesn't seem to recognize it:

REPLACE(TextString,' ','') AS TextClean,

Remove an unwanted special character

Anonymous — Wed, 30 May 2012 16:38:05 GMT

Had to insert a picture since it wouldn't display in the forum. This is fiendish little character! Any ideas to dispose of it are welcome.

Remove an unwanted special character

RedSky001 — Wed, 30 May 2012 16:50:12 GMT

Do you know what the special character actually is?

ie if it was a tab you could do purgechar(TextString,char(9))

Replace 9 with the correct value.

Mark

Remove an unwanted special character

Anonymous — Wed, 30 May 2012 18:10:07 GMT

OK, so I think the character is Unicode U+25A1. I am not sure there is a conversion to ASCII. If there was, I could use CHR(). Is there a way to add support for this unicode character in my script or another function that would handle this?

Re: Remove an unwanted special character

Qrishna — Fri, 10 Apr 2015 20:46:26 GMT

Hi Aaron,

You can use PurgeChar() function to remove unwanted characters from a string.

Eg: If one of the record in the field Full_Name: Jam3e#s Ca%mer~on

Then PurgeChar(Full_Name,'3,#,%,~') returns Full_Name: James Cameron.

Hope that helps.

Thanks

krishna

Re: Remove an unwanted special character

Fri, 10 Apr 2015 21:02:33 GMT

Please use KeepChar

eg: KeepChar(Field,'abcdefg......xyz1234567890') as Field