Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marksmunich
Creator III
Creator III

Wildcard match with 'like'

Hi Community,

Can i Use Like with Wildcard where i do not speciy any characters but just Wildcard match Format

example :

Load

field1,

field2

From Table1 Where Field1 like '?????-????-*' ;

in the above example the the Patterns which i Need to load must be something like  ghfds-fdsd-sdds or dsasdf-fgds-sd

The table contains more than 50000 rows. this Special pattern which has 5 characters in the begining and then a '-' 4 characters and then '-' and followed by any characters. This pattern indicates a product category. so i want to load this pattern.

thanks

Mark

3 Replies
maxgro
MVP
MVP

may be with wildmatch

where

     wildmatch(Field1, '?????-????-*')

;

from online help

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

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

JonnyPoole
Employee
Employee

i ran a couple of tests and it seems to work .   * and ? are acceptable wildcards.

Did you get an error ?

marksmunich
Creator III
Creator III
Author

Ist working now. There was a small mistake, fixed it...