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: 
Not applicable

Find a specific text in a field

Hello everyone,

I have to put a condition on a field:

the sql looks like this:

upper(pp.name)  like '%PARCHETUL%' OR upper(pp.name)  like '%PREFECT%' OR......

how can this conditions be implemented into a expression from a table.

The only functions I have found are: left() right() mid()...but this can't be used...

Help me please in this small problem.

Thank you in advance!

Silviu

2 Replies
Not applicable
Author

I think the function you are looking for is wildmatch.  It would work something like:

Expression Definition:

= IF(wildmatch(name field, '*PARCHETUL*','*PREFECT*',etc...),1,0) or whatever you want to display for the expression when you find a match or not rather than the 1 and 0.

Wildmatch returns true for each string found.  The * is the equivalent of the % in sql.

Not applicable
Author

thank you!

I will try to use wildmatch. Hope it works.

good day,

Silviu