Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

diff btn wildmatch and wildmatch5?

what is the diff btn wildmatch and wildmatch5?

2 Replies
Highlighted
Champion
Champion

Re: diff btn wildmatch and wildmatch5?

Did you check this?

wildmatch() and wildmatch5()

Highlighted

Re: diff btn wildmatch and wildmatch5?

wildmatch( s, expr1 [ , expr2, ...exprN ] )

Compares the string s to a list of strings or string expressions. The

result of the comparison is an integer indicating which of the comparison

strings/expressions that matched. If no match is found, 0 is

returned. The wildmatch function performs a case insensitive comparison.

The wildcard characters * and ? are allowed in the comparison

string.

Examples:

wildmatch( M , 'ja*' , 'fe?' , 'mar' )

where M is 'January' returns 1

wildmatch( M , 'ja*' , 'fe?' , 'mar' )

where M is 'fex' returns 2

Wildmatch5(s,expr1 [,expr2,...exprN])

Works as the above wildmatch function, but is used only for compatibility

reasons with QlikView version 5

check this

wildmatch() and wildmatch5()