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.