Wildcards within an IF statement in a Script

[Anonymous]

Hi everyone,

I multiple IF statements for data scrubbing purposes.  I've tested one but when I use a wildcard it just doesn't work. It seems to ignore it or it tries to literally search for the asterisk within the field data. I also tried % character for a wildcard. No luck.

If ([Make] = 'Mercedes', 'Mercedes Benz', [Make])

If ([Make] = 'Mercedes*', 'Mercedes Benz', [Make])   (doesn't work)

[#2]

Hi Brian,

Try If(Wildmatch([Make],'Mercedes*')=1,'Mercedes Benz',[Make])

You can read more about Wildmatch function in reference manual or QlikView Help.

BR,

Milosz

[alexpanjhc]

if (wildmatch([Make] , 'Mercedes*')>0,'Mercedes Benz', [Make])

[sunny_talwar]

Or this:

If(Index(Make, 'Mercedes'), 'Mercedes Benz', Make)

[holmlund]

If(Make like '*Mercedes*', Make)

[MarcoWedel]

If ([Make] like 'Mercedes*', 'Mercedes Benz', [Make])

[MarcoWedel]

Hi,

maybe also helpful:

if condition

regards

Marco

[Anonymous]

Thank you very much everyone for the WILDMATCH function and the INDEX. I just looked them up in the reference. Wildmatch says it is case sensitive. Sunny do you know if the same is so for Index?

[sunny_talwar]

I think Index is case sensitive as well. To get around this, you can use Upper() or Lower() functions:

If(Index(Lower(Make), 'mercedes'), 'Mercedes Benz', Make)

[MarcoWedel]

WildMatch() and like both are case insensitive.

wildmatch ‒ QlikView

regards

Marco