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)
Try If(Wildmatch([Make],'Mercedes*')=1,'Mercedes Benz',[Make])
You can read more about Wildmatch function in reference manual or QlikView Help.
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?
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)