topic Re: Wildmatch in script in QlikView

Wildmatch in script

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Is there a way i can use a CHR() in a wildmatch where clause?

I am trying to find data with a ^ in it , but when i try

Where Wildmatch([Field Name],'*^');

i get nothing back.

I am guessing it doesnt like the ^ so i was wondering if i could use the CHR() istaed '(CHR(93)'

does anyone know how i would write that?

swuehl — Wed, 31 Oct 2018 18:42:54 GMT

Have you tried index instead?

WHERE Index(FIELD, '^');

WHERE Right(FIELD,1) = '^';

hopkinsc — Wed, 31 Oct 2018 18:48:04 GMT

Thats great, i didnt try index() Thanks very much!

vishsaggi — Wed, 31 Oct 2018 18:48:17 GMT

May be try this?

WildMatch([Field Name], '*'&$(=Chr(94))&'*')

andrey_krylov — Wed, 31 Oct 2018 18:54:55 GMT

Were looking looking for solution))