topic Re: If Function with a special character in QlikView

If Function with a special character

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Im having trouble with an If( Function in my Qlikview Load.

In the datafiles, its possible to select 'favorite' fields that are marked with a star symbol in the
Qlikview Logfiles. The character code for that star is: chr(9734)

Now I want it to be possible that I delete the star symbol when its occurring in the table value.
I used an If( function like this: If(Wildmatch(Message, chr(9734)), PurgeChar(Message, chr(9734)))

But it didn't work.
Maybe its part of the If function or the Purgechar that wont work.

Anyone can help me with this issue?

Thanks in Advance!

Ivo

Re: If Function with a special character

Anil_Babu_Samineni — Tue, 20 Dec 2016 07:28:48 GMT

Do you mean, you want to delete Star from that list?

Update: Just use

PurgeChar(Message, chr(9734))

You can play round to achieve this

Re: If Function with a special character

avinashelite — Tue, 20 Dec 2016 07:52:33 GMT

replace(Message,chr(9734),'')

Re: If Function with a special character

Tue, 20 Dec 2016 07:56:27 GMT

Thanks for your reply

I've tried different things with the PurgeChar function, but it doesnt work...

I dont know if its because of the chr(9734) or something else.

Re: If Function with a special character

Tue, 20 Dec 2016 08:15:48 GMT

I really think it has to do with they function itself.

If I put in another character or line of text, it doesnt work either.

Re: If Function with a special character

Gysbert_Wassenaar — Tue, 20 Dec 2016 08:32:52 GMT

Are you still using the Wildmatch function? If so you need to change that a bit:

If(Wildmatch(Message, '*' & chr(9734) & '*'), PurgeChar(Message, chr(9734)))

Otherwise you'll only get a match in Message contains only that star character and no other text at all.

The purgechar function works in a test here. If it doesn't work for you then perhaps the star character you see is not chr(9734) but another character.

You can also try the keepchar function: Keepchar(Message, '0123456789abcdef...etc...xyzABCDE....etc...XYZ')

Re: If Function with a special character

vinieme12 — Tue, 20 Dec 2016 08:41:17 GMT

Directly input as text

Example

purgechar('☆TODAY' ,'☆')

Re: If Function with a special character

varshavig12 — Tue, 20 Dec 2016 08:51:21 GMT

PurgeChar() should work for you.

If it is still not working then as Gysbert said, it might be some other character.

Try using Vineeth's exp, i.e directly copy that character in your exp.

Re: If Function with a special character

Tue, 20 Dec 2016 08:52:06 GMT

Thanks for all the replies guys!

I figured out how to solve my problem by using multiple Replace() functions.
That, because the original message line was "Chart: 'Star symbol' text.

I replaced the 'Chart: Star symbol' part, the 'Chart: ' part and the 'star symbol' part in this order.

Replace(Replace(Replace('_Chart: ☆ ',''), '_Chart: ', ''), '☆ ', '') <- Like this

Re: If Function with a special character

vinieme12 — Tue, 20 Dec 2016 08:56:54 GMT

Even this will work , purgechar(MESSAGE ,'_Chart: ☆')

No need for so many Replace()'s

Re: If Function with a special character

Tue, 20 Dec 2016 09:03:47 GMT

This doesnt work unfortunately, because it will also do a purgechar on every single _, C, h, a, r, t, too.
Theres a text behind the Chart: ☆ that get completely messed up by the purgechar function, so I guess its best to go with the multiple replaces for now.

Thanks for your input though!