wildmatch() and wildmatch5()

[#1]

What is the difference between WildMatch() and WildMatch5() functions?

[#2 · Accepted solution]

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

[#3]

Thanks.  I had seen that quesion here: http://qlikshare.com/qotd, and wondered whether it meant anything.

[#4]

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

???

[#5]

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