Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the difference between WildMatch() and WildMatch5() functions?
hi,
Wildmatch() is a QlikView Function and wildmatch5() is not anymore.
The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters (
* and ?) in the comparison strings.
Example:
wildmatch( M, 'ja*','fe?','mar')
returns 1 if M = January
returns 2 if M = fex
Wildmatch5(s,expr1 [,expr2,...exprN])
Works as the above wildmatch function, but is used only for compatibility
reasons with QlikView version 5.
Regards,
Gerrit
hi,
Wildmatch() is a QlikView Function and wildmatch5() is not anymore.
The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters (
* and ?) in the comparison strings.
Example:
wildmatch( M, 'ja*','fe?','mar')
returns 1 if M = January
returns 2 if M = fex
Wildmatch5(s,expr1 [,expr2,...exprN])
Works as the above wildmatch function, but is used only for compatibility
reasons with QlikView version 5.
Regards,
Gerrit
Thanks. I had seen that quesion here: http://qlikshare.com/qotd, and wondered whether it meant anything.
Chris, If I have a table like this:
Column A
TEST
test
TeSt
and in the load i do:
Load
wildmatch (Column A) it will all group as:
Column A
test
???
Hi,
Have you got any answer on your question asked in qlikview.
I also have the same kind of requirement.
If you got anything do share..
Thks
Poshkant