Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there a similar function to SQL 'LIKE' in QlikView script?

I have a field that I need to interrogate.

If it contains a certain string then it needs to do a 'textbetween' function on 2 characters, if it contains a different string then it does a 'textbetween' on 2 other characters.

logically I want to say:
if field TEXTCOL LIKE '%changed the field% then do this

else if field TEXTCOL LIKE '%user-defined%' then do that.

...if that makes sense...

thank in advance,

Matt

Labels (1)
1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Matt,

try WILDMATCH

cheers

Ask me about Qlik Sense Expert Class!